Re: WAL Files checkpoint_timeout with voluminous delete/insert

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hervé Piedvache <herve(at)elma(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: WAL Files checkpoint_timeout with voluminous delete/insert
Date: 2003-08-22 20:43:52
Message-ID: 5379.1061585032@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?iso-8859-15?q?Herv=E9=20Piedvache?= <herve(at)elma(dot)fr> writes:
> I have a dedicated partition on the disk for the WAL files, 2Gb.

> So I start my script and saw the size of the pg_xlog partition groing quickly
> to be full after 20 min ...

That shouldn't happen, unless there's something preventing automatic
checkpoints from occurring. What do you have checkpoint_segments set
to?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jenny Zhang 2003-08-22 21:13:19 how to get accurate values in pg_statistic
Previous Message Mike Mascari 2003-08-22 20:29:49 Re: Single-file DBs WAS: Need concrete "Why Postgres