Re: Vacuum, Freeze and Analyze: the big picture - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Vacuum, Freeze and Analyze: the big picture
Date
Msg-id 51A7A605.3050700@agliodbs.com
Whole thread Raw
In response to Vacuum, Freeze and Analyze: the big picture  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Vacuum, Freeze and Analyze: the big picture  (Andres Freund <andres@2ndquadrant.com>)
List pgsql-hackers
> If we have reason to vacuum the relation we do it at
> vacuum_freeze_table_age, not only at autovacuum_max_freeze_age. The
> difference is that the latter triggers a vacuum, while the former only
> changes a partial vacuum into a full one.
> 
> Calling that behaviour unconditionally worse is, err, interesting...

*overall* it's better.  But as far as FREEZE itself is concerned, it's
worse.

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



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Vacuum, Freeze and Analyze: the big picture
Next
From: Andres Freund
Date:
Subject: Re: Freezing without write I/O