Re: Optimization for lazy_scan_heap - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Optimization for lazy_scan_heap
Date
Msg-id 2d08d103-8477-47c0-e76b-5f178125c474@BlueTreble.com
Whole thread Raw
In response to Re: Optimization for lazy_scan_heap  (Masahiko Sawada <sawada.mshk@gmail.com>)
Responses Re: Optimization for lazy_scan_heap  (Masahiko Sawada <sawada.mshk@gmail.com>)
List 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



pgsql-hackers by date:

Previous
From: Rahila Syed
Date:
Subject: Re: Surprising behaviour of \set AUTOCOMMIT ON
Next
From: Jim Nasby
Date:
Subject: Re: Vacuum: allow usage of more than 1GB of work mem