Re: [HACKERS] WAL logging problem in 9.4.3? - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [HACKERS] WAL logging problem in 9.4.3?
Date
Msg-id 20191124125316.GC2266@paquier.xyz
Whole thread Raw
In response to Re: [HACKERS] WAL logging problem in 9.4.3?  (Noah Misch <noah@leadboat.com>)
List pgsql-hackers
On Sat, Nov 23, 2019 at 11:35:09AM -0500, Noah Misch wrote:
> That longstanding optimization is too useful to remove, but likely not useful
> enough to add today if we didn't already have it.  The initial-data-load use
> case remains plausible.  I can also imagine using wal_level=minimal for data
> warehouse applications where one can quickly rebuild from the authoritative
> data.

I can easily imagine cases where a user would like to use the benefit
of the optimization for an initial data load, and afterwards update
wal_level to replica so as they avoid the initial WAL burst which
serves no real purpose.  So the first argument is pretty strong IMO,
the second much less.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Copyright information in source files
Next
From: Ranier Vilela
Date:
Subject: [PATCH] Fix var declaration according scanf specification,