Bgwriter and pg_stat_bgwriter.buffers_clean aspects - Mailing list pgsql-general

From Dmitry Koterov
Subject Bgwriter and pg_stat_bgwriter.buffers_clean aspects
Date
Msg-id d7df81620812251337s41fcbefdyf7089dd8c57e6214@mail.gmail.com
Whole thread Raw
Responses Bgwriter and pg_stat_bgwriter.buffers_clean aspects
List pgsql-general
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

pgsql-general by date:

Previous
From: "Victor Nawothnig"
Date:
Subject: get the array value?
Next
From: "Dmitry Koterov"
Date:
Subject: Bgwriter and pg_stat_bgwriter.buffers_clean aspects