[GENERAL] Bgwriter and pg_stat_bgwriter.buffers_clean aspects

2008-12-25 Thread Dmitry Koterov
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 *

[GENERAL] Bgwriter and pg_stat_bgwriter.buffers_clean aspects

2008-12-25 Thread Dmitry Koterov
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 *