On 2/15/12, Tomas Vondra <tv@xxxxxxxx> 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? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
