[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    [GENERAL] pg_restore performance on solaris 10/6
From:       Thomas Burns <tombu () schoolloop ! com>
Date:       2006-07-31 19:45:51
Message-ID: 80EA80DA-B70D-4603-866B-D728E2E52A93 () schoolloop ! com
[Download RAW message or body]

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



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org
[prev in list] [next in list] [prev in thread] [next in thread]