OSDN Git Service

Just-in-time background writing strategy. This code avoids re-scanning
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 25 Sep 2007 20:03:38 +0000 (20:03 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 25 Sep 2007 20:03:38 +0000 (20:03 +0000)
commit6f5c38dcd0dfb391bcbaa683a96f4a62c574d95a
tree720d4cd3b589bdff97825ed56cc5e1de706bcd87
parent588901df84588981aabf40df3287219405ec443b
Just-in-time background writing strategy.  This code avoids re-scanning
buffers that cannot possibly need to be cleaned, and estimates how many
buffers it should try to clean based on moving averages of recent allocation
requests and density of reusable buffers.  The patch also adds a couple
more columns to pg_stat_bgwriter to help measure the effectiveness of the
bgwriter.

Greg Smith, building on his own work and ideas from several other people,
in particular a much older patch from Itagaki Takahiro.
16 files changed:
doc/src/sgml/config.sgml
doc/src/sgml/monitoring.sgml
src/backend/catalog/system_views.sql
src/backend/postmaster/bgwriter.c
src/backend/postmaster/pgstat.c
src/backend/storage/buffer/bufmgr.c
src/backend/storage/buffer/freelist.c
src/backend/utils/adt/pgstatfuncs.c
src/backend/utils/misc/guc.c
src/backend/utils/misc/postgresql.conf.sample
src/include/catalog/catversion.h
src/include/catalog/pg_proc.h
src/include/pgstat.h
src/include/storage/buf_internals.h
src/include/storage/bufmgr.h
src/test/regress/expected/rules.out