Postgres Pro
Downloads
Home   >   mailing lists

Re: autovacuum not prioritising for-wraparound tables - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: autovacuum not prioritising for-wraparound tables
Date
Msg-id 5109E7F2.30205@agliodbs.com
Whole thread Raw
In response to Re: autovacuum not prioritising for-wraparound tables  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-hackers
Tree view 
> 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

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Review : Add hooks for pre- and post-processor executables for COPY and \copy
Next
From: Tatsuo Ishii
Date:
Subject: Re: review: pgbench - aggregation of info written into log