Re: WAL insert delay settings - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: WAL insert delay settings
Date
Msg-id CAH2-Wz=A_8p7K4KuZpHrAvk4-nyOdWHpSEjw+tjCtuWAZay-VA@mail.gmail.com
Whole thread Raw
In response to Re: WAL insert delay settings  (Andres Freund <andres@anarazel.de>)
Responses Re: WAL insert delay settings  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
On Thu, Feb 14, 2019 at 12:42 AM Andres Freund <andres@anarazel.de> wrote:
> That can't have been the workaround - either you'd interrupt it while
> holding critical locks (in which case nobody could write WAL anymore),
> or you'd just move all the writing to backends, no?

I imagine that it held the critical locks briefly. I'm not endorsing
that approach, obviously, but apparently it more or less worked. It
was something that was used in rare cases, only when there was no
application-specific way to throttle writes, and only when the server
was in effect destabilized by writing out WAL too quickly.

-- 
Peter Geoghegan


pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: WAL insert delay settings
Next
From: Peter Geoghegan
Date:
Subject: Re: WAL insert delay settings