Thanks for your help, its working now :-).
Tom Lane wrote:
> Dario Brignardello <dbrignar(at)sinectis(dot)com> writes:
> > checkpoint_segments = 1
> > checkpoint_timeout = 30
> Reducing checkpoint_segments and checkpoint_timeout is actually
> seriously counterproductive, if your problem is amount of disk space
> chewed up by WAL logs during a long transaction (such as bulk load of
> a big table). The WAL log cannot be truncated until the xact commits,
> so the checkpoints that happen meanwhile just cause log bloat. Lots
> of it, because each checkpoint causes fresh copying of modified pages
> into the WAL log.
> Try increasing those numbers, not decreasing them. Maybe 10/600 or so?
> Also, if you are short on disk space for WAL, increasing wal_files isn't
> such a great idea either.
> regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2001-05-23 18:45:55|
|Subject: Re: Postgres 7.0.3 Dying |
|Previous:||From: Thalis A. Kalfigopoulos||Date: 2001-05-23 17:23:02|
|Subject: Re: WAL and backup recovery |