Bgwriter and pg_stat_bgwriter.buffers_clean aspects

From: "Dmitry Koterov" <dmitry(at)koterov(dot)ru>
To: "Postgres General" <pgsql-general(at)postgresql(dot)org>
Subject: Bgwriter and pg_stat_bgwriter.buffers_clean aspects
Date: 2008-12-25 21:37:08
Message-ID: d7df81620812251337s41fcbefdyf7089dd8c57e6214@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

Hello.

I am trying to tune PostgreSQL write parameters to make writing operation
fast on a heavy-loaded database (a lot of inserts/updates).
After resetting the pg_stat_bgwriter statistics (I do it by deleting
global/pgstat.stat file and restarting PostgreSQL) I monitor the following:

# select * from pg_stat_bgwriter;
checkpoints_timed | checkpoints_req | buffers_checkpoint | buffers_clean |
maxwritten_clean | buffers_backend | buffers_alloc
-------------------+-----------------+--------------------+---------------+------------------+-----------------+---------------
0 | 0 | 0 | 0
| 0 | 164 | 6653

So, you see that just after resetting the statistics we have a large value
in buffers_backend. Why?
Documentation:
http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm
says that "buffers_backend

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitry Koterov 2008-12-25 21:43:44 Bgwriter and pg_stat_bgwriter.buffers_clean aspects
Previous Message Victor Nawothnig 2008-12-25 20:06:02 get the array value?

Browse pgsql-performance by date

  From Date Subject
Next Message Dmitry Koterov 2008-12-25 21:43:44 Bgwriter and pg_stat_bgwriter.buffers_clean aspects
Previous Message Kynn Jones 2008-12-24 18:56:28 Re: How to "unique-ify" HUGE table?