[postgis-users] Select Query Performance

David Blasby dblasby at refractions.net
Mon Jun 2 10:39:19 PDT 2003

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 

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 


More information about the postgis-users mailing list