| 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: | Whole Thread | Raw Message | 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? |