Re: Memory tuning Postgres

On 2/15/12, Tomas Vondra <tv@fuzzy.cz> wrote:
> On 15 Únor 2012, 15:20, Robert James wrote:
>> What parameters should I change to use the server best? What are good
>> starting points or them? What type of performance increase should I
>> see?

...
> But you haven't
> mentioned which version of PostgreSQL is used and what is the size of the
> database.


Pg 8.3, Linux.  Each individual database when dumped to a .sql file
takes between 1 - 3 GB.

> The other parameters that may be interesting are probably
> checkpoint_segments, checkpoint_completion_target, work_mem,
> maintenance_work_mem (read the wiki, it's described there).
>
> You should also tweak the log_line_prefix (use something that works with
> pgfounie), log_checkpoints/log_temp_files and maybe set reasonable value
> to log_statement_min_duration.


Thanks.  Can you give me starting points for those for a 4 core 4 GB
Ram server with about 10 GB of data?