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@schoolloop.com
415.255.7285