The suggestion of reducing autovacuum_vacuum_cost_delay should be documented

2020-05-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/runtime-config-autovacuum.html Description: The `autovacuum_vacuum_cost_delay` setting changes to 2ms in PostgreSQL 12 but in the old Postgresql version, the default setting is still 20ms.

dot dot dot dot

2020-05-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/tutorial-sql-intro.html Description: is wrong.

https://www.postgresql.org/docs/11/typeconv-union-case.html

2020-05-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/typeconv-union-case.html Description: I think it should be CAST instead of CASE.

Re: https://www.postgresql.org/docs/11/typeconv-union-case.html

2020-05-12 Thread David G. Johnston
On Tuesday, May 12, 2020, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/11/typeconv-union-case.html > Description: > > I think it should be CAST instead of CASE. > Why? There no “process” needed to per

Re: The suggestion of reducing autovacuum_vacuum_cost_delay should be documented

2020-05-12 Thread Bruce Momjian
On Tue, May 12, 2020 at 10:26:27AM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/11/runtime-config-autovacuum.html > Description: > > The `autovacuum_vacuum_cost_delay` setting changes to 2ms in P

Re: The suggestion of reducing autovacuum_vacuum_cost_delay should be documented

2020-05-12 Thread Bruce Momjian
On Tue, May 12, 2020 at 05:40:14PM -0400, Bruce Momjian wrote: > On Tue, May 12, 2020 at 10:26:27AM +, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > > > Page: https://www.postgresql.org/docs/11/runtime-config-autovacuum.html > > Descrip

Re: The suggestion of reducing autovacuum_vacuum_cost_delay should be documented

2020-05-12 Thread David G. Johnston
On Tue, May 12, 2020 at 2:41 PM Bruce Momjian wrote: > On Tue, May 12, 2020 at 05:40:14PM -0400, Bruce Momjian wrote: > > On Tue, May 12, 2020 at 10:26:27AM +, PG Doc comments form wrote: > > > The following documentation comment has been logged on the website: > > > > > > Page: > https://www

Re: The suggestion of reducing autovacuum_vacuum_cost_delay should be documented

2020-05-12 Thread Bruce Momjian
On Tue, May 12, 2020 at 03:38:16PM -0700, David G. Johnston wrote: > On Tue, May 12, 2020 at 2:41 PM Bruce Momjian wrote: > > On Tue, May 12, 2020 at 05:40:14PM -0400, Bruce Momjian wrote: > > On Tue, May 12, 2020 at 10:26:27AM +, PG Doc comments form wrote: > > > The following do

Re: The suggestion of reducing autovacuum_vacuum_cost_delay should be documented

2020-05-12 Thread Tom Lane
Bruce Momjian writes: > On Tue, May 12, 2020 at 03:38:16PM -0700, David G. Johnston wrote: >> The proposal is to document in versions 9.4 to 11 that the recommended value >> for the setting is 2ms while for reasons of continuity the default in these >> versions is 20ms. >> I don't really see any h

Re: The suggestion of reducing autovacuum_vacuum_cost_delay should be documented

2020-05-12 Thread Bruce Momjian
On Tue, May 12, 2020 at 07:26:07PM -0400, Tom Lane wrote: > Bruce Momjian writes: > > On Tue, May 12, 2020 at 03:38:16PM -0700, David G. Johnston wrote: > >> The proposal is to document in versions 9.4 to 11 that the recommended > >> value > >> for the setting is 2ms while for reasons of continui

Re: The suggestion of reducing autovacuum_vacuum_cost_delay should be documented

2020-05-12 Thread David G. Johnston
On Tue, May 12, 2020 at 4:30 PM Bruce Momjian wrote: > On Tue, May 12, 2020 at 07:26:07PM -0400, Tom Lane wrote: > > Bruce Momjian writes: > > > On Tue, May 12, 2020 at 03:38:16PM -0700, David G. Johnston wrote: > > >> The proposal is to document in versions 9.4 to 11 that the > recommended valu

Re: The suggestion of reducing autovacuum_vacuum_cost_delay should be documented

2020-05-12 Thread Tom Lane
"David G. Johnston" writes: > To be clear, because my cursory reading of the thread that was linked from > the commit suggested that this specific situation was more "lets catch up > to modern times", my position isn't that such documentation changes should > be done as a rule, I am suggesting tha

Re: The suggestion of reducing autovacuum_vacuum_cost_delay should be documented

2020-05-12 Thread David G. Johnston
On Tue, May 12, 2020 at 4:59 PM Tom Lane wrote: > "David G. Johnston" writes: > > To be clear, because my cursory reading of the thread that was linked > from > > the commit suggested that this specific situation was more "lets catch up > > to modern times", my position isn't that such documenta