[postgis-users] Select Query Performance
dblasby at refractions.net
Mon Jun 2 09:24:09 PDT 2003
Riyaz Prasla wrote:
> I am running Postgresql 7.2.3 on a linux Qube with
> 256 RAM. I have a table with about 100,000 records.
> The table has a postgis geometry column. I have a GIST
> index on the table on the geometry column. Here are my
> 1)When I do a spatial select query on the geometry
> column in this table it takes a few seconds. What more
> can I do in terms of the Postgresql configuration or
> query tuning besides adding the GIST index?
This is usually caused by not doing a vacuum analyse:
-# vacuum analyse;
If that doesnt help - how many records are being returned by the query?
More information about the postgis-users