Re: pg_restore taking 4 hours!

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Vivek Khera <khera(at)kcilink(dot)com>
Subject: Re: pg_restore taking 4 hours!
Date: 2004-12-13 18:25:54
Message-ID: 200412131025.54587.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

Vivek,

> The biggest improvement in speed to restore time I have discovered is
> to increase the checkpoint segments.  I bump mine to about 50.  And
> moving the pg_xlog to a separate physical disk helps a lot there, too.

Don't leave it at 50; if you have the space on your log array, bump it up to
256.

--
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2004-12-13 18:26:49 Re: subscribe missing?
Previous Message Igor Shevchenko 2004-12-13 18:18:57 partial index on boolean, problem with v8.0.0rc1

Browse pgsql-performance by date

  From Date Subject
Next Message sarlav kumar 2004-12-13 18:31:13 Re: INSERT question
Previous Message Bruce Momjian 2004-12-13 18:20:14 Re: Alternatives to Dell?