Adrian,
For tuning tips a good start is:
http://wiki.postgresql.org/wiki/Performance_Optimization
In particular:
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
For books take a look at:
http://www.postgresql.org/docs/books/
thank you very much. Reading them requires lot of time. I'm looking for
quick optimization for 2 GB RAM.
postgresql.conf contains
shared_buffers = 24MB # min 128kB
#temp_buffers = 8MB # min 800kB
#max_prepared_transactions = 0 # zero disables the feature
#work_mem = 1MB # min 64kB
#maintenance_work_mem = 16MB # min 1MB
#max_stack_depth = 2MB # min 100kB
Probably only few settings like shared_buffers needs adjusting for 2 gb
In windows I use enterpicedb tuning wizard which does this automatically.
Maybe something works in Debian also.
Or this there quick guide how to change most important settings.
Andrus.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
