[postgis-users] upgrade benefits re. high load

[Paul Ramsey]

Tuning PostGIS == Tuning PostgreSQL, with the minor exception of running 
update_geometry_stats() regularly on <=7.4 version databases.

Tuning PostgreSQL (or any database) is a dark art, but there are a 
couple references (note to self, write definitive reference on 
PostgreSQL tuning, ... profit!)

- http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
- http://www.postgresql.org/docs/aw_pgsql_book/hw_performance/

Note that we spatial people generally have a simpler tuning case than 
"real" DBAs, because our databases usually have practically no 
transactional load: they are pure batch loaded, with a heavy read load 
and very light write load. (I await someone giving me their counter 
example, it would probably make a great PostGIS white paper.)

Paul


Ethan Alpert wrote:

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