Re: How to install latest stable postgresql on Debian
От | Andrus |
---|---|
Тема | Re: How to install latest stable postgresql on Debian |
Дата | |
Msg-id | A78BF44ACE6E49C1B08B3C2360C896CA@dell2 обсуждение исходный текст |
Ответ на | Re: How to install latest stable postgresql on Debian (Adrian Klaver <adrian.klaver@gmail.com>) |
Ответы |
Re: How to install latest stable postgresql on Debian
|
Список | pgsql-general |
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.
В списке pgsql-general по дате отправления: