Re: patch to allow disable of WAL recycling - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: patch to allow disable of WAL recycling
Date
Msg-id 20180716025427.GN27724@tamriel.snowman.net
Whole thread Raw
In response to Re: patch to allow disable of WAL recycling  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: patch to allow disable of WAL recycling  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
Greetings,

* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> I think that the right basic idea is to have a GUC that chooses between
> the two implementations, but whether it can be set automatically is not
> clear to me.  Can initdb perhaps investigate what kind of filesystem the
> WAL directory is sitting on, and set the default value from hard-wired
> knowledge about that?

Maybe..  but I think we'd still need a way to change it because people
often start with their database system minimally configured (including
having WAL in the default location of the data directory) and only later
realize that was a bad idea and change it later.  I wouldn't be at all
surprised if that "change it later" meant moving it to a different
filesystem, and having to re-initdb to take advantage of that would be
particularly unfriendly.

Thanks!

Stephen

Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Refactor documentation for wait events (Was: pgsql: Add wait eventfor fsync of WAL segments)
Next
From: "Tsunakawa, Takayuki"
Date:
Subject: RE: How to make partitioning scale better for larger numbers ofpartitions