[postgis-users] upgrade benefits re. high load

[Ethan Alpert]

Hmm..tuning...

Where does one go to learn about tuning postgis? I don't see anything on
postgis.org. Do I need to look at postgres.org?

I inherited a > 30 million tuple database which I'm sure no one ever
considered tuning once it went live.

-e

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: Thursday, September 30, 2004 8:35 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] upgrade benefits re. high load

Have you done any tuning to your pgsql installation at all? Possibly 
some tuning of your database server would be sufficient to make you get 
better performance, without the need to move on to lwgeom. Really, if 
you don't have > 1million tuples in your database, lwgeom is unlikely 
to make much difference to you one way or another.