[postgis-users] Select Query Performance

[David Blasby]

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?


dave