Re: How to determine a database is intact?

From: Wes <wespvp(at)syntegra(dot)com>
To: Vivek Khera <khera(at)kcilink(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to determine a database is intact?
Date: 2004-09-09 17:31:03
Message-ID: BD65FD87.10CDE%wespvp@syntegra.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/9/04 9:27 AM, "Vivek Khera" <khera(at)kcilink(dot)com> wrote:

> I shaved significant time from 7.4.x restores by bumping up the
> checkpoint_segments to 50. My dumps currently take about 1.5 hours
> over a 100Mbit ethernet (server is on gig ethernet, dumping client is
> on 100Mbit).

Mine are already set to 30, but in a recent re-index, I saw warnings in the
log so need to bump it up some more. I'm going to likely be doing a reload
this weekend, so will include this in the run.

Wes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karl O. Pinc 2004-09-09 17:35:14 Obtaining the Julian Day from a date
Previous Message Wes 2004-09-09 17:30:31 Re: How to determine a database is intact?