[OSM-dev] PostgreSQL Optimizations?
borgers at mi.fu-berlin.de
Fri Feb 18 19:00:13 GMT 2011
I think the actual configuration depends on your system and the free
resources you have. You should give us a little bit more information
about expected connections, available ram, update interval of your
database and so on.
General information about postgres resource configuration can be found
Google returns a lot of information on postgres and tuning :)
Am Freitag, den 18.02.2011, 08:55 -0600 schrieb Samir Faci (Dev):
> I initially followed this guide when setting up OSM + Renderd.
> I've matched the suggestions made in the guide:
> shared_buffers = 128MB
> checkpoint_segments = 20
> maintenance_work_mem = 256MB
> autovacuum = off
> I keep hearing debate about autovacum being turned on or off, but that
> aside are there any other performance suggestions?
> The machine is essentially processing 100% of the time or close enough to it.
> Should any of those values be larger? I have ram to spare, that's not
> an issue.. but most guide seem to have those values or similar.
> Any particular rule of thumb... or configs that people have found that
> work better then others?
> Samir Faci
More information about the dev