pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: tv@fuzzy.cz
To: Uwe Bartels <uwe.bartels@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: buffercache/bgwriter
Date: Wed, 23 Mar 2011 15:41:40 +0100
Message-ID: <a07f7dd81de8049b622b52710e163d54.squirrel@sq.gransy.com> (raw)
In-Reply-To: <AANLkTi=hL_-85=daT1WKwdptZrBxuUn=phLUwYPwtVwC@mail.gmail.com>
References: <AANLkTi=hL_-85=daT1WKwdptZrBxuUn=phLUwYPwtVwC@mail.gmail.com>

> Hi,
>
> I have very bad bgwriter statistics on a server which runs since many
> weeks
> and it is still the same after a recent restart.
> There are roughly 50% of buffers written by the backend processes and the
> rest by checkpoints.
> The statistics below are from a server with 140GB RAM, 32GB shared_buffers
> and a runtime of one hour.
>
> As you can see in the pg_buffercache view that there are most buffers
> without usagecount - so they are as free or even virgen as they can be.
> At the same time I have 53% percent of the dirty buffers written by the
> backend process.

There are some nice old threads dealing with this - see for example

http://postgresql.1045698.n5.nabble.com/Bgwriter-and-pg-stat-bgwriter-buffers-clean-aspects-td207147...

http://postgresql.1045698.n5.nabble.com/tuning-bgwriter-in-8-4-2-td1926854.html

and there even some nice external links to more detailed explanation

http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm

regards
Tomas

view thread (14+ messages)  latest in thread

Message-ID: <a07f7dd81de8049b622b52710e163d54.squirrel@sq.gransy.com>
Permalink:  ../a07f7dd81de8049b622b52710e163d54.squirrel@sq.gransy.com/
Also on:    postgresql.org/message-id/a07f7dd81de8049b622b52710e163d54.squirrel@sq.gransy.com

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tv@fuzzy.cz, uwe.bartels@gmail.com
  Subject: Re: buffercache/bgwriter
  In-Reply-To: <a07f7dd81de8049b622b52710e163d54.squirrel@sq.gransy.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox