Re: .ready and .done files considered harmful - Mailing list pgsql-hackers

From Robert Haas
Subject Re: .ready and .done files considered harmful
Date
Msg-id CA+Tgmoa4=k3CeGh+OX0D9+p7Nmj3ZYaeD2ahk+=n0Bz7m5d_HA@mail.gmail.com
Whole thread Raw
In response to Re: .ready and .done files considered harmful  (Stephen Frost <sfrost@snowman.net>)
Responses Re: .ready and .done files considered harmful  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers
On Wed, May 5, 2021 at 1:06 PM Stephen Frost <sfrost@snowman.net> wrote:
> It's not just about making sure that we archive the history file for a
> timeline before archiving WAL segments along that timeline but also
> about making sure we get that history file into the archive as fast as
> we can, and archiving a 16MB WAL first would certainly delay that.

Ooph. That's a rather tough constraint. Could we get around it by
introducing some kind of signalling mechanism, perhaps? Like if
there's a new history file, that must mean the server has switched
timelines -- I think, anyway -- so if we notified the archiver every
time there was a timeline switch it could react accordingly.

-- 
Robert Haas
EDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: COPY table_name (single_column) FROM 'iso-8859-1.txt' DELIMITER E'\n'
Next
From: Peter Geoghegan
Date:
Subject: Re: MaxOffsetNumber for Table AMs