Re: should I worry?

Heikki Linnakangas <heikki@enterprisedb.com>

From: Heikki Linnakangas <heikki@enterprisedb.com>
To: ohp@pyrenet.fr
Cc: pgsql-hackers list <pgsql-hackers@postgresql.org>
Date: 2007-11-02T18:11:14Z
Lists: pgsql-hackers
ohp@pyrenet.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