On 10/5/16 7:34 AM, Greg Spiegelberg wrote:
> When you say "must do a vacuum of the entire database", are you saying
> the entire database must be vacuum'd as a whole per 2B transactions or
> all tables must be vacuum'd eventually at least once?
All tables at least once. Prior to 9.6, that had to happen ever 2B
transactions. With 9.6 there's a freeze map, so if a page never gets
dirtied between vacuum freeze runs then it doesn't need to be frozen.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532) mobile: 512-569-9461