On Sun, Feb 10, 2019 at 10:05 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Peter Geoghegan <pg@bowt.ie> writes:
> > On Fri, Feb 8, 2019 at 6:00 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> The v10 release notes just say
>
> Reduce page locking during vacuuming of <acronym>GIN</acronym> indexes
> (Andrey Borodin)
>
> so it doesn't seem like there's any difference at that level of detail.
> But I'll expand the new release note, say
>
> This change partially reverts a performance improvement, introduced
> in version 10, that attempted to reduce the number of index pages
> locked during deletion of a GIN posting tree page. That's now been
> found to lead to deadlocks, so we've removed it pending closer
> analysis.
That plan seems sensible to me. The wording looks good, too.
--
Peter Geoghegan