On 1 November 2012 17:19, Shaun Thomas <sthomas@xxxxxxxxxxxxxxxx> wrote: > On 11/01/2012 10:28 AM, Kevin Grittner wrote: > Based on my past experience with 8.2, and my understanding of 9.1, I > moved autovacuum_freeze_max_age up to 650M so we'd never get a mid-day > freeze. And the default for vacuum_freeze_table_age is 150M, which I hadn't > changed. Instead of attempting to postpone freeze until beyond the life expectancy of our universe, what you probably should have done is vacuum more often so that vacuum has less work to do. -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
