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

Поиск
Список
Период
Сортировка
От Chris Wilson
Тема Re: What does "[backends] should seldom or never need to wait for a write to occur" mean?
Дата
Msg-id CAOg7f82Hpz3jO6W+SJq6RYLpiH=LhUDBpSST5RZhTJOiEYPcNQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: What does "[backends] should seldom or never need to wait for a write to occur" mean?  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-docs
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 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 <bruce@momjian.us> wrote:
On Thu, Nov 12, 2020 at 02:40:04PM +0000, 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't seen anything about a minimum percentage before the bgwriter kicks
> in, is that really the case? How is it configured?

Yes, I see your point.  My language was not accurate, and it didn't
match the actual background writer tuning parameters below this text.
Here is an updated doc patch.

I agree this text should be as clear as possible because there is no way
to properly tune the background writer parameters unless we explain how
it works.   It is good you noticed this.

--
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EnterpriseDB                             https://enterprisedb.com

  The usefulness of a cup is in its emptiness, Bruce Lee

В списке pgsql-docs по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: What does "[backends] should seldom or never need to wait for a write to occur" mean?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: What does "[backends] should seldom or never need to wait for a write to occur" mean?