Postgres Pro
Downloads
Home   >   mailing lists

Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock(PG10.7) - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock(PG10.7)
Date
Msg-id CAH2-WzmiARA7NJy3cyH_VMyxoM306J_+mAH3uAavmDVxUdrGyQ@mail.gmail.com
Whole thread Raw
In response to Re: Connections hang indefinitely while taking a gin index's LWLockbuffer_content lock(PG10.7)  (Andrey Borodin <x4mmm@yandex-team.ru>)
List pgsql-hackers
Tree view 
On Sun, Sep 29, 2019 at 10:38 PM Andrey Borodin <x4mmm@yandex-team.ru> wrote:
> As far as I understand deleted page is stamped with
> GinPageSetDeleteXid(page, ReadNewTransactionId());
> It will not be recycled until that Xid is far behind.

That only gets used within posting tree pages, though.
ginInsertCleanup() is concerned with pending list pages.

> BTW we found a small bug (wraparound) in similar GiST and B-tree implementations.
> Probably, it's there in GIN too.

Probably, but that's much less of a problem to me.

-- 
Peter Geoghegan

pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: Partitioning versus autovacuum
Next
From: Alvaro Herrera
Date:
Subject: Re: Commit fest 2019-09