From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | "Andrus" <kobruleht2(at)hot(dot)ee> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to install latest stable postgresql on Debian |
Date: | 2011-11-19 19:44:42 |
Message-ID: | 201111191144.43341.adrian.klaver@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Saturday, November 19, 2011 10:36:37 am Andrus wrote:
> 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.
From here(look familiar):
http://wiki.postgresql.org/wiki/Performance_Optimization
http://linuxfinances.info/info/quickstart.html
http://www.westnet.com/~gsmith/content/postgresql/pg-5minute.htm
>
> Andrus.
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2011-11-19 19:49:11 | Re: How to install latest stable postgresql on Debian |
Previous Message | Tomas Vondra | 2011-11-19 19:38:14 | Re: Logging not working |