Postgres Pro
Downloads
Home   >   mailing lists

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

From Alexander Korotkov
Subject Re: [HACKERS] GUC for cleanup indexes threshold.
Date
Msg-id CAPpHfdvS7sbyNU7tAHbEEmSNW46qYyTJkvbykb1Sqg28_dtj1A@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] GUC for cleanup indexes threshold.  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
List pgsql-hackers
Tree view
On Sat, Mar 10, 2018 at 5:49 PM, Alexander Korotkov <a.korotkov@postgrespro.ru> wrote:
On Fri, Mar 9, 2018 at 9:40 PM, Alexander Korotkov <a.korotkov@postgrespro.ru> wrote:
On Fri, Mar 9, 2018 at 3:12 PM, Masahiko Sawada <sawada.mshk@gmail.com> wrote:
Attached an updated patch
fixed these issue. Will review the patch again.

Thank you!

I've fixed a bug: _bt_vacuum_needs_cleanup() didn't release a lock when metapage is in old format.
Bug was found by Darafei Praliaskouski and Grigory Smolkin who tested this patch.
Revised patch is attached.

I also found that online upgrade of meta-page didn't work: version field wasn't set.
Fixed in the attached version of patch.

------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company 
Attachment

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Parallel Aggregates for string_agg and array_agg
Next
From: Amit Kapila
Date:
Subject: Re: [HACKERS] why not parallel seq scan for slow functions