Re: BUG #6170: hot standby wedging on full-WAL disk - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #6170: hot standby wedging on full-WAL disk
Date
Msg-id CA+Tgmoa_gycDVqH088gqYrsUF=gO_x-Df3hgvTS1Gxm2orKJnA@mail.gmail.com
Whole thread Raw
In response to Re: BUG #6170: hot standby wedging on full-WAL disk  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: BUG #6170: hot standby wedging on full-WAL disk
List pgsql-bugs
On Mon, Aug 22, 2011 at 2:57 AM, Heikki Linnakangas
<heikki.linnakangas@enterprisedb.com> wrote:
> So the problem is that walreceiver merrily writes so much future WAL that it
> runs out of disk space? A limit on the maximum number of future WAL files to
> stream ahead would fix that, but I can't get very excited about it. Usually
> you do want to stream as much ahead as you can, to ensure that the WAL is
> safely on disk on the standby, in case the master dies. So the limit would
> need to be configurable.

It seems like perhaps what we really need is a way to make replaying
WAL (and getting rid of now-unneeded segments) to take priority over
getting new ones.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-bugs by date:

Previous
From: Chander Ganesan
Date:
Subject: Re: BUG #6176: pg_dump dumps pg_catalog tables
Next
From: "Claudio Oliveira"
Date:
Subject: BUG #6177: Size field type TEXT