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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
