| From: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
|---|---|
| To: | Greg Spiegelberg <gspiegelberg(at)gmail(dot)com> |
| Cc: | "Alex Ignatov (postgrespro)" <a(dot)ignatov(at)postgrespro(dot)ru>, Terry Schmitt <tschmitt(at)schmittworks(dot)com>, pgsql-performa(dot) <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Millions of tables |
| Date: | 2016-10-08 21:42:01 |
| Message-ID: | bce33408-16f1-fb5d-671a-f73072c83bc3@BlueTreble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrzej Zawadzki | 2016-10-10 15:31:28 | Why query plan is different? |
| Previous Message | Greg Spiegelberg | 2016-10-05 12:34:02 | Re: Millions of tables |