diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2014-01-18 19:24:20 -0500 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2014-01-18 19:24:33 -0500 |
| commit | 115f414124e71749d2d8f512e469ca63bc2166e5 (patch) | |
| tree | ab361085d44a3491bc034041470a2fab1c644e92 /contrib/btree_gist/sql/bytea.sql | |
| parent | 76e91b38ba64e1da70ea21744b342cb105ea3400 (diff) | |
Fix VACUUM's reporting of dead-tuple counts to the stats collector.
Historically, VACUUM has just reported its new_rel_tuples estimate
(the same thing it puts into pg_class.reltuples) to the stats collector.
That number counts both live and dead-but-not-yet-reclaimable tuples.
This behavior may once have been right, but modern versions of the
pgstats code track live and dead tuple counts separately, so putting
the total into n_live_tuples and zero into n_dead_tuples is surely
pretty bogus. Fix it to report live and dead tuple counts separately.
This doesn't really do much for situations where updating transactions
commit concurrently with a VACUUM scan (possibly causing double-counting or
omission of the tuples they add or delete); but it's clearly an improvement
over what we were doing before.
Hari Babu, reviewed by Amit Kapila
Diffstat (limited to 'contrib/btree_gist/sql/bytea.sql')
0 files changed, 0 insertions, 0 deletions
