Re: Sum of written buffers bigger than allocation?

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Sum of written buffers bigger than allocation?
Дата
Msg-id CAMkU=1wcaFqx-JVNQ=T5wgu7ceCRsNRnTy7PjPOKSivLwnujvg@mail.gmail.com
обсуждение исходный текст
Ответ на Sum of written buffers bigger than allocation?  (pinker <pinker@onet.eu>)
Список pgsql-general


On Sun, Apr 8, 2018 at 11:28 AM, pinker <pinker@onet.eu> wrote:


It's kinda mysterious... Any explanations?
Does it mean that the same buffers were written over and over again?


Yeah, checkpoints will write all dirty buffers, but doesn't evict them.  Next time the page is needed, it doesn't need to be re-read as it is still there.

Cheers,

Jeff

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

Предыдущее
От: pinker
Дата:
Сообщение: Sum of written buffers bigger than allocation?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Conflict between JSON_AGG and COPY