Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] GUC for cleanup indexes threshold. - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: [HACKERS] GUC for cleanup indexes threshold.
Date
Msg-id CANP8+jJQ=Nx7uBy5UOPQVbJ+_KmkY67cRjZE3M0wBUC5RMU2DA@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] GUC for cleanup indexes threshold.  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
Responses Re: [HACKERS] GUC for cleanup indexes threshold.  (Masahiko Sawada <sawada.mshk@gmail.com>)
List pgsql-hackers
Tree view 
On 25 September 2017 at 22:34, Kyotaro HORIGUCHI
<horiguchi.kyotaro@lab.ntt.co.jp> wrote:

>> > Here is a small patch that skips scanning btree index if no pending
>> > deleted pages exists.
>> > It detects this situation by comparing pages_deleted with pages_free.
>
> It seems to work to prevent needless cleanup scans.

So this leaves us in the situation that

1. Masahiko's patch has unresolved problems
2. Yura's patch works and is useful

Unless there is disagreement on the above, it seems we should apply
Yura's patch (an edited version, perhaps).

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

pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: PATCH: pgbench - option to build using ppoll() for largerconnection counts
Next
From: Stephen Frost
Date:
Subject: Re: [HACKERS] postgres_fdw super user checks