[postgis-users] Select Query Performance
riyazprasla at yahoo.com
Mon Jun 2 09:44:56 PDT 2003
I am doing a Vacuum Analyze after creating the
Around 3000 records are being returned on the query.
--- David Blasby <dblasby at refractions.net> wrote:
> Riyaz Prasla wrote:
> > Hi,
> > I am running Postgresql 7.2.3 on a linux Qube
> > 256 RAM. I have a table with about 100,000
> > The table has a postgis geometry column. I have a
> > 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
> > can I do in terms of the Postgresql configuration
> > query tuning besides adding the GIST index?
> This is usually caused by not doing a vacuum
> -# vacuum analyse;
> If that doesnt help - how many records are being
> returned by the query?
> postgis-users mailing list
> postgis-users at postgis.refractions.net
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
More information about the postgis-users