[OSM-dev] PostgreSQL Optimizations?
Philipp Borgers
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
here:
http://www.postgresql.org/docs/8.3/static/runtime-config-resource.html
Google returns a lot of information on postgres and tuning :)
Best regards
philippp
Am Freitag, den 18.02.2011, 08:55 -0600 schrieb Samir Faci (Dev):
> I initially followed this guide when setting up OSM + Renderd.
>
> http://weait.com/content/build-your-own-openstreetmap-server
>
> 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
mailing list