Re: Optimization for lazy_scan_heap - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Optimization for lazy_scan_heap
Date
Msg-id CANP8+jJxP=5bRVincoxAKyiLMpanCLmrbDbbwRjAW9-GT=GhUA@mail.gmail.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
List pgsql-hackers
On 7 September 2016 at 04:13, Masahiko Sawada <sawada.mshk@gmail.com> wrote:

> Since current HEAD could scan visibility map twice, the execution time
> of Patched is approximately half of HEAD.

Sounds good.

To ensure we are doing exactly same amount of work as before, did you
see the output of VACUUM VEROBOSE?

Can we produce a test that verifies the result patched/unpatched?

-- 
Simon Riggs                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Andrew Borodin
Date:
Subject: Re: GiST penalty functions [PoC]
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Supporting SJIS as a database encoding