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