Re: autovacuum not prioritising for-wraparound tables

Alvaro Herrera <alvherre@2ndquadrant.com>

From: Alvaro Herrera <alvherre@2ndquadrant.com>

To: Christopher Browne <cbbrowne@gmail.com>

Cc: Andres Freund <andres@2ndquadrant.com>, Tom Lane <tgl@sss.pgh.pa.us>, Heikki Linnakangas <hlinnakangas@vmware.com>, Pg Hackers <pgsql-hackers@postgresql.org>

Date: 2013-01-31T19:40:14Z

Lists: pgsql-hackers

Attachments

autovacuum-toast-wraparound-2.patch (text/x-diff) patch

Alvaro Herrera escribió:

> Okay, here's a patch along these lines.  I haven't considered Jim's
> suggestion downthread about discounting dead tuples from relpages; maybe
> we can do that by subtracting the pages attributed to dead ones,
> estimating via tuple density (reltuples/relpages).

Patch attached.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

Commits

COPY FREEZE and mark committed on fresh tables.
- 8de72b66a2ed 9.3.0 cited
Add vacuum_freeze_table_age GUC option, to control when VACUUM should
- 6587818542e7 8.4.0 cited