Re: [BUGS] Documentation bug: reference to checkpoint activity in bgwriter
On 20 January 2012 02:53, Robert Haas wrote: > OK, done. Thanks -- Peter Geoghegan http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training and Services -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] Documentation bug: reference to checkpoint activity in bgwriter
On Mon, Jan 9, 2012 at 2:37 PM, Peter Geoghegan wrote: > On 9 January 2012 18:47, Robert Haas wrote: >> On Sat, Dec 31, 2011 at 8:54 PM, Peter Geoghegan >> wrote: >>> ISTM that the following reference, at config.sgml line 1345, ought to >>> be adjusted due to the introduction of the new checkpointer process: >>> >>> Setting this to zero disables >>> background writing (except for checkpoint activity). >> >> Hmm, so what should we adjust it *to*? > > How about "Setting this to zero disables background writing. Note that > checkpoints, which are managed by a separate, dedicated auxiliary > process, are unaffected." > > If this was the first release of Postgres, I'd suggest that we remove > any references to checkpoints, which are sort of orthogonal to the > stated main function of the bgwriter in past releases, which is to > clean dirty buffers so that backends don't have to. However, people > may still expect the bgwriter to manage checkpointing, particularly if > they're working off old sources of information, so it's useful to set > them straight. OK, done. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] Documentation bug: reference to checkpoint activity in bgwriter
On 9 January 2012 18:47, Robert Haas wrote: > On Sat, Dec 31, 2011 at 8:54 PM, Peter Geoghegan > wrote: >> ISTM that the following reference, at config.sgml line 1345, ought to >> be adjusted due to the introduction of the new checkpointer process: >> >> Setting this to zero disables >> background writing (except for checkpoint activity). > > Hmm, so what should we adjust it *to*? How about "Setting this to zero disables background writing. Note that checkpoints, which are managed by a separate, dedicated auxiliary process, are unaffected." If this was the first release of Postgres, I'd suggest that we remove any references to checkpoints, which are sort of orthogonal to the stated main function of the bgwriter in past releases, which is to clean dirty buffers so that backends don't have to. However, people may still expect the bgwriter to manage checkpointing, particularly if they're working off old sources of information, so it's useful to set them straight. -- Peter Geoghegan http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training and Services -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] Documentation bug: reference to checkpoint activity in bgwriter
On Sat, Dec 31, 2011 at 8:54 PM, Peter Geoghegan wrote: > ISTM that the following reference, at config.sgml line 1345, ought to > be adjusted due to the introduction of the new checkpointer process: > > Setting this to zero disables > background writing (except for checkpoint activity). Hmm, so what should we adjust it *to*? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs