[postgis-users] Select Query Performance
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