| From: | Thomas Burns <tombu(at)schoolloop(dot)com> |
|---|---|
| To: | Vivek Khera <vivek(at)khera(dot)org> |
| Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_restore performance on solaris 10/6 |
| Date: | 2006-08-03 00:05:05 |
| Message-ID: | D26FE896-B993-4178-B573-4670D978ED0C@schoolloop.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)schoolloop(dot)com
415.255.7285
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Fetter | 2006-08-03 01:24:40 | Re: SELinux + CREATE TABLESPACE = ? |
| Previous Message | David Fetter | 2006-08-02 23:47:36 | SELinux + CREATE TABLESPACE = ? |