[postgis-users] Select Query Performance

[Riyaz Prasla]

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

Riyaz


--- David Blasby <dblasby at refractions.net> wrote:
> 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
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
>
http://postgis.refractions.net/mailman/listinfo/postgis-users


__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com