Postgres Pro
Downloads
Home   >   mailing lists

Re: Sum of written buffers bigger than allocation? - Mailing list pgsql-general

From Jeff Janes
Subject Re: Sum of written buffers bigger than allocation?
Date
Msg-id CAMkU=1wcaFqx-JVNQ=T5wgu7ceCRsNRnTy7PjPOKSivLwnujvg@mail.gmail.com
Whole thread Raw
In response to Sum of written buffers bigger than allocation?  (pinker <pinker@onet.eu>)
List pgsql-general
Tree view


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 by date:

Previous
From: pinker
Date:
Subject: Sum of written buffers bigger than allocation?
Next
From: Adrian Klaver
Date:
Subject: Re: Conflict between JSON_AGG and COPY