On Aug 1, 2006, at 8:52 AM, Vivek Khera wrote:
On Jul 31, 2006, at 3:45 PM, Thomas Burns wrote:
our database literally takes 8 times longer on the x4200 as it
does on
OS X (the x4200 hardware should be considerably faster -- it has
better
for a restore like this, bump up the value of checkpoint_segments
to some large value (I use 256 -- but I have a dedicated partition
for the pg_xlog directory which gets big).
will give that a shot
also, the normal tuning of the shared memory settings apply. how
much RAM do you have and what kind of disks are you using?
I have 50000 shared buffers and 10000 temp buffers (the machine has
16G ram). The disks are new/fast SCSI drives
Thomas E. Burns
Co-Founder/CTO, Schoolloop.com
http://www.schoolloop.com
tombu@xxxxxxxxxxxxxx
415.255.7285
