Re: Missing file is mentioned on page https://www.postgresql.org/docs/13/libpq-exec.html

On Tue, Nov 10, 2020 at 07:23:12PM -0500, Bruce Momjian wrote: > On Tue, Nov 10, 2020 at 06:15:29PM -0500, Tom Lane wrote: > > Bruce Momjian writes: > > > On Fri, Oct 30, 2020 at 11:09:58AM -0400, Tom Lane wrote: > > >> Thinking about it from the perspective of someone dealing with an > > >> insta

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

Hi Bruce, Thanks, I absolutely agree that this documentation needs to explain properly how the bgwriter works. Your latest patch looks good, it significantly improves this section of the manual. I would just suggest changing "non-dirty" to "clean" in "When the number of non-dirty shared buffers ap

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

On Thu, Nov 12, 2020 at 05:25:30PM +, Chris Wilson wrote: > Hi Bruce, > > Thanks, I absolutely agree that this documentation needs to explain properly > how the bgwriter works. Your latest patch looks good, it significantly > improves > this section of the manual. I would just suggest changin

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

On Thu, Nov 12, 2020 at 02:40:04PM +, Chris Wilson wrote: > Hi Bruce, > > Thanks, yes I agree that that is much clearer. However when you say: > > > When the percentage of dirty shared buffers is high, the background writer > writes some of them to the file system... > > > I haven'

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

Hi Bruce, Thanks, yes I agree that that is much clearer. However when you say: When the percentage of dirty shared buffers is high, the background writer > writes some of them to the file system... I haven't seen anything about a minimum percentage before the bgwriter kicks in, is that really t

Re: Documentation of return values of range functions lower and upper

On Wed, 2020-11-11 at 18:19 +0100, Laurenz Albe wrote: > > Table 9.54 in page > > https://www.postgresql.org/docs/current/functions-range.html states that the > > functions lower and upper return NULL if the requested bound is infinite. If > > the element type of the range contains the special valu

doc: index items for pg_stat_progress_xxx views

Hi, The index items for pg_stat_progress_xxx views point to the "Viewing Statistics" section, but not to the dedicated section (e.g., "ANALYZE Progress Reporting") for each view. IMO this is very inconvenient when finding the section describing each pg_stat_progress_xxx view, from the index. So w