Re: Reducing pg_dump & pg_restore times

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 10/27/06 02:26, Coder At Heart wrote:
> Hi!
>
> Thanks so much for the responses. The system configuration is something
> like
> this-

That's a start...

> Linux,

Presumably a 2.6 kernel? Which, and which distro version?

PG 8.1,

OK

ext3,

OK

RAID 1 setup with two controllers

Not enough info.

Soft RAID, controller RAID, IDE, SATA, SCSI U160, U320, SAS, 10K
RPM, 15K RPM, etc, etc?

And tape drive. What kind of tape drive?

Are the disks on one controller and the tape drive on another?

> The machine has 4 processors with 32 Gig of RAM.

Presumably modern. AMD, Intel, GHz?

And then there's SK's suggestions:

>> *) increasing maintainance_work_mem and work_mem massively
>> *) increasing the number of checkpoint segments
>> *) disabling fsync during the load

> Thanks!
> Shivkumar
>
> On 10/27/06, Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> wrote:
>>
>> Ron Johnson wrote:
>> > On 10/26/06 01:20, Chris wrote:
>> >>> Coder At Heart wrote:
>> >>>> Hi!
>> >>>>
[snip]
>>
>> >
>> > So,
>> > - What OS?
>> > - What version of PG?
>> > - what kind of disk system does the DB live on?
>> > - How many controllers?
>> > - What kind of tape drive?
>> > - Is it on it's own SCSI controller?
>>
>> in addition to that basic information we need there are:
>>
>> *) increasing maintainance_work_mem and work_mem massively
>> *) increasing the number of checkpoint segments
>> *) disabling fsync during the load

- --
Ron Johnson, Jr.
Jefferson LA USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQFFQdEoS9HxQb37XmcRAt2GAKCVARbdY5wwcoOIINP22T9u/1VA1wCgo9F+
Qi5ou/YfdLCjzcpmRHONlwE=
=ONU4
-----END PGP SIGNATURE-----