pg_restore performance on solaris 10/6
Hi,
We recently started using a Sun x4200 with Solaris 10/6 (the release
from jun of 2006) and postgresql 8.1.3. I think I may need to do some
tuning, but have no idea what to change. Using pg_restore to restore
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
drives, more RAM, faster processors and 4 cores vs 2 cores). The
loadavg
on the x4200 during the restore is extremely low -- about 0.01 (on OS X,
it would be more like 1.5 or 2.0). Any idea what could be going on?
Thanks,
Tom Burns
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).
also, the normal tuning of the shared memory settings apply. how
much RAM do you have and what kind of disks are you using?
Attachments:
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
betterfor 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
On Aug 2, 2006, at 8:05 PM, Thomas Burns wrote:
I have 50000 shared buffers and 10000 temp buffers (the machine has
16G ram). The disks are new/fast SCSI drives
what's their configuration? RAID? if so, what controller and setup?
if not, what controller and setup?
without all the details of your setup, it is impossible to offer
suggestions.