Re: autovacuum not prioritising for-wraparound tables

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: Andres Freund <andres(at)2ndquadrant(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: autovacuum not prioritising for-wraparound tables
Date: 2013-01-31 03:41:38
Message-ID: 5109E7F2.30205@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> You can get nearly all the benefits of your "sane" settings just by
> increasing autovacuum_freeze_max_age and leaving vacuum_freeze_min_age
> alone. (Assuming the table doesn't get vacuumed for other reasons)

Correct, it's the ratio that matters.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2013-01-31 07:05:43 Re: review: pgbench - aggregation of info written into log
Previous Message Amit Kapila 2013-01-31 03:39:58 Re: Review : Add hooks for pre- and post-processor executables for COPY and \copy