pg_restore performance on solaris 10/6

From: Thomas Burns <tombu(at)schoolloop(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_restore performance on solaris 10/6
Date: 2006-07-31 19:45:51
Message-ID: 80EA80DA-B70D-4603-866B-D728E2E52A93@schoolloop.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2006-07-31 19:55:08 Re: pg_xlog not cleaned up
Previous Message Francisco Reyes 2006-07-31 19:43:31 Re: VACUUM FULL versus CLUSTER ON