pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Pallav Kalva <pkalva@deg.cc>
To: pgsql-admin@postgresql.org
Subject: Postgresql settings help for 8.0.1
Date: Wed, 06 Apr 2005 09:54:01 -0400
Message-ID: <4253E9F9.7050703@deg.cc> (raw)

Hi,

   I posted this message earlier but i didnt get any responses, i am 
posting here again. We are migrating to a new server with more memory 
and also from postgres 7.4 to postgres 8.0.1 version.

Here are my settings on the current 7.4 version:
OS : RedHat 9
CPUS: 2 hyperthreaded
Memory: 4gig
shared_buffers: 65536
sort_mem: 16384
vacuum_mem: 32768
wal_buffers: 64
effective_cache_size: 393216
checkpoint_segments: 3
checkpoint_timeout: 300
checkpoint_warning: 30

These are settings which I am planning on the new machine with 8.0.1 
version:
OS: Fedora Core 2
CPUs: 2 hyperthreaded
Memory: 8 gig
shared_buffers: 131072
work_mem: 32768
maintanence_work_mem: 65536
wal_buffers: 64
effective_cache_size: 786432
checkpoint_segments: 8
checkpoint_timeout: 600
checkpoint_warning: 30

   The current settings on my 7.4 version gives me very good 
performance, so I basically doubled the settings since i will be having 
the double the memory in the new machine. What my concern is about the 
effective_cache_settings , according the docs its recommends me to set 
max to about 2/3 of the total memory and I went little over on top of 
it, is that ok ? I went little over on my current 7.4 system too, and 
its giving me very good performance so I used the same calculation for 
my new system too.
  Also, can anyone guide me with the ideal settings for 
vacuum_cost_delay, vacuum_cost_page_hit, vacuum_cost_page_miss, 
vacuum_cost_page_dirty, vacuum_cost_limit,  background_delay, 
bgwriter_percent, bgwriter_maxpages settings. I am not sure what 
settings should I make to these parameters , are there any ideal 
settings for these parameters in a OLTP environment ?

Thanks!
Pallav




view thread (2+ messages)  latest in thread

Message-ID: <4253E9F9.7050703@deg.cc>
Permalink:  ../4253E9F9.7050703@deg.cc/
Also on:    postgresql.org/message-id/4253E9F9.7050703@deg.cc

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: pkalva@deg.cc
  Subject: Re: Postgresql settings help for 8.0.1
  In-Reply-To: <4253E9F9.7050703@deg.cc>
  References: <4253E9F9.7050703@deg.cc>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox