Re: Don't removes/recycles WAL files at all

From: Richard Huxton <dev(at)archonet(dot)com>
To: Michael Govorun <mike(at)shpion(dot)ru>, pgsql-general(at)postgresql(dot)org
Subject: Re: Don't removes/recycles WAL files at all
Date: 2003-07-30 18:47:48
Message-ID: 200307301947.48861.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday 30 July 2003 18:54, Michael Govorun wrote:
> Please, help.
>
> versions: 7.3.3, 7.3.4
>
> Server don't recycles or removes WAL files at all, generating 12-20 files
> every day.
>
> -rw------- 1 postgres postgres 16777216 Jul 29 01:54 0000000000000000
> -rw------- 1 postgres postgres 16777216 Jul 29 01:55 0000000000000001
[...etc]

First thing I'd look for is if there is an old uncommitted transaction lurking
around somewhere. If the transaction doesn't commit, the WAL will need to
keep that data around.

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Govorun 2003-07-30 19:05:32 Re: Don't removes/recycles WAL files at all
Previous Message Dennis Gearon 2003-07-30 18:39:25 Re: Diff between contrib/dbmirror and rserv