Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group