Search Postgresql Archives

Re: Sum of written buffers bigger than allocation?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Sum of written buffers bigger than allocation?
From: Jeff Janes <jeff.janes@xxxxxxxxx>
Date: Sun, 8 Apr 2018 11:53:31 -0400
Cc: Postgres General <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <1523201315068-0.post@n3.nabble.com>
References: <1523201315068-0.post@n3.nabble.com>

On Sun, Apr 8, 2018 at 11:28 AM, pinker <pinker@xxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Sum of written buffers bigger than allocation?
  - From: pinker

Prev by Date: Sum of written buffers bigger than allocation?
Next by Date: Re: Conflict between JSON_AGG and COPY
Previous by thread: Sum of written buffers bigger than allocation?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux