aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2006-01-18 20:35:16 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2006-01-18 20:35:16 +0000
commit0bfd90ff32bb18cc0201a7194cd9bef6d152e802 (patch)
treeae97eba1ffc0f40b325c3de249bae24535b86a43 /doc/src
parent9e72b3c2c5328d375ca4dad245a3be7b7bd55228 (diff)
downloadpostgresql-0bfd90ff32bb18cc0201a7194cd9bef6d152e802.tar.gz
postgresql-0bfd90ff32bb18cc0201a7194cd9bef6d152e802.zip
Modify pgstats code to reduce performance penalties from oversized stats data
files: avoid creating stats hashtable entries for tables that aren't being touched except by vacuum/analyze, ensure that entries for dropped tables are removed promptly, and tweak the data layout to avoid storing useless struct padding. Also improve the performance of pgstat_vacuum_tabstat(), and make sure that autovacuum invokes it exactly once per autovac cycle rather than multiple times or not at all. This should cure recent complaints about 8.1 showing much higher stats I/O volume than was seen in 8.0. It'd still be a good idea to revisit the design with an eye to not re-writing the entire stats dataset every half second ... but that would be too much to backpatch, I fear.
Diffstat (limited to 'doc/src')
0 files changed, 0 insertions, 0 deletions