[postgis-users] Select Query Performance

David Blasby dblasby at refractions.net
Mon Jun 2 09:24:09 PDT 2003

Riyaz Prasla wrote:
> Hi,
>   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
> questions: 
> 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 mailing list