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
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? |
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? |