Robert Haas wrote: > On Thu, Aug 25, 2016 at 3:21 PM, Alvaro Herrera > <alvhe...@2ndquadrant.com> wrote:
> > Does it work to set the minimum to one WAL segment, i.e. 64MB? guc.c > > has a hardcoded minimum of 2, but I couldn't find an explanation for it. > > Well, I think that when you overrun the end of one segment, you're > never going to be able to wrap around to the start of the same > segment; you're going to get sucked into needing another file. Sure, but that's a transient situation; after a couple of checkpoints, the old segment can be removed without any danger, leaving only the active segment. [thinks] Ah, on reflection, there's no way that this buys anything: it is always critical to have enough disk space to have one more segment to switch to. So even if you're on tight disk constraints, you cannot afford to allocate space for a single segment only, because if you only have that and the need comes to create the next one to switch to, you will just not have the space. If we were to use the WAL space in a way different than the POSIX file interface, we could probably do better. But that seems too onerous. I suppose the only option is to keep the minimum at 2. I don't see any point in forcing the minimum to be more than that, however. -- Álvaro Herrera http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers