Re: should I worry?

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: ohp(at)pyrenet(dot)fr
Cc: pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: should I worry?
Date: 2007-11-02 18:11:14
Message-ID: 472B6842.7030104@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

ohp(at)pyrenet(dot)fr wrote:
> I'm now testing 8.3beta2 on a relatively big (10G) database.
> I've tried with pg_dymp -Fc/pg_restore and pg_dump/pgsql and get those
> errors:

Could you be a bit more specific? The database you tried to restore to
was empty, right? Can you post the dump file (schema-only)?

> I'm also playing with checkpoint logging. What should I see? few buffers
> dump, little write time, little sync time?

Depends on how much activity there is. If there's a lot of dirty
buffers, a lot of written buffers and long write time is perfectly normal.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-11-02 18:19:24 Re: Proposal: Select ... AS OF Savepoint
Previous Message Andrew Dunstan 2007-11-02 17:44:11 Re: minimal update