| From: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
|---|---|
| To: | Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Optimization for lazy_scan_heap |
| Date: | 2016-09-08 14:27:19 |
| Message-ID: | 2d08d103-8477-47c0-e76b-5f178125c474@BlueTreble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 9/8/16 3:03 AM, Masahiko Sawada wrote:
> Current manual vacuum doesn't output how may all_frozen pages we
> skipped according to visibility map.
> That's why I attached 0001 patch which makes the manual vacuum emit
> such information.
I think we should add that, and info about all-frozen skips, regardless
of the rest of these changes. Can you submit that separately to the
commitfest? (Or I can if you want.)
--
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 | Jim Nasby | 2016-09-08 14:35:29 | Re: Vacuum: allow usage of more than 1GB of work mem |
| Previous Message | Rahila Syed | 2016-09-08 14:13:15 | Re: Surprising behaviour of \set AUTOCOMMIT ON |