Re: What does "[backends] should seldom or never need to wait for a write to occur" mean?

2020-11-12 Thread Chris Wilson
non-dirty shared buffers appears to be insufficient", as this makes the language simpler and avoids introducing another new term (non-dirty, which means the same as clean). Thanks again, Chris. On Thu, 12 Nov 2020 at 16:54, Bruce Momjian wrote: > On Thu, Nov 12, 2020 at 02:40:04PM +,

Re: What does "[backends] should seldom or never need to wait for a write to occur" mean?

2020-11-12 Thread Chris Wilson
t really the case? How is it configured? Thanks, Chris. On Wed, 11 Nov 2020 at 23:24, Bruce Momjian wrote: > On Wed, Nov 11, 2020 at 11:29:09AM +0000, Chris Wilson wrote: > > I still believe that my original proposed change, to "This reduces the > chances > > that a backe

Re: What does "[backends] should seldom or never need to wait for a write to occur" mean?

2020-11-11 Thread Chris Wilson
10 Nov 2020 at 16:08, Bruce Momjian wrote: > On Mon, Nov 9, 2020 at 08:36:32PM -0500, Bruce Momjian wrote: > > On Tue, Nov 3, 2020 at 06:11:21PM +, Chris Wilson wrote: > > > Hi all, > > > > > > I did some more research and found this explanation in a pre

Re: What does "[backends] should seldom or never need to wait for a write to occur" mean?

2020-11-03 Thread Chris Wilson
it." Thanks, Chris. On Mon, 2 Nov 2020 at 12:38, Chris Wilson wrote: > Hi all, > > Thanks Thomas. > > When the bgwriter flushes (cleans) a dirty Postgres buffer, it generates a > write() syscall of its own, which I think must increase the number of dirty > cache buff

Re: What does "[backends] should seldom or never need to wait for a write to occur" mean?

2020-11-02 Thread Chris Wilson
Hi all, Thanks Thomas. When the bgwriter flushes (cleans) a dirty Postgres buffer, it generates a write() syscall of its own, which I think must increase the number of dirty cache buffers in the Linux kernel (temporarily, until it actually flushes those cache buffers to disk). Therefore it tempor

Re: bgwriter_lru_multiplier maximum value

2019-04-01 Thread Chris Wilson
Hi all, We do document the range for some parameters: - bgwriter_flush_after: "The valid range is between 0, which disables forced writeback, and 2MB." - effective_io_concurrency (integer): "The allowed range is 1 to 1000, or zero to disable issuance of asynchronous I/O requests."