[postgis-users] Select Query Performance

[David Blasby]

Riyaz Prasla wrote:
> Hi David,
>     I am doing a Vacuum Analyze after creating the
> GIST index. 
>  Around 3000 records are being returned on the query.

Sound fishy - pulling 3,000 records from 100,000 should be really really 
fast.

Are you doing the query from the psql command line?  If your geometries 
are large, your 3,000 records could take a long time to send over the 
internet.

dave