[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] upgrade benefits re. high load
From: Paul Ramsey <pramsey () refractions ! net>
Date: 2004-09-30 16:08:33
Message-ID: 415C2F81.5040905 () refractions ! net
[Download RAW message or body]
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@postgis.refractions.net
> [mailto:postgis-users-bounces@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@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic