Postgres Pro
Downloads
Home   >   mailing lists

Re: WAL Files checkpoint_timeout with voluminous delete/insert - Mailing list pgsql-general

From Tom Lane
Subject Re: WAL Files checkpoint_timeout with voluminous delete/insert
Date
Msg-id 5379.1061585032@sss.pgh.pa.us
Whole thread Raw
In response to WAL Files checkpoint_timeout with voluminous delete/insert  (Hervé Piedvache <herve@elma.fr>)
Responses Re: WAL Files checkpoint_timeout with voluminous delete/insert  (Hervé Piedvache <herve@elma.fr>)
List pgsql-general
Tree view 
=?iso-8859-15?q?Herv=E9=20Piedvache?= <herve@elma.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

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: convert interval info into days
Next
From: Jenny Zhang
Date:
Subject: how to get accurate values in pg_statistic