Re: gist microvacuum doesn't appear to care about hot standby?

From: Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>
To: Andres Freund <andres(at)anarazel(dot)de>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Teodor Sigaev <teodor(at)sigaev(dot)ru>, Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>
Subject: Re: gist microvacuum doesn't appear to care about hot standby?
Date: 2018-12-16 22:03:52
Message-ID: CAPpHfdsf4d71qHYZUXN8YMapzma9T+XBcawVqvfeUwRXhSKoOA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Dec 13, 2018 at 7:28 AM Alexander Korotkov
<a(dot)korotkov(at)postgrespro(dot)ru> wrote:
> On Thu, Dec 13, 2018 at 1:45 AM Andres Freund <andres(at)anarazel(dot)de> wrote:
> > Is there any reason something like that isn't necessary for gist? If so,
> > where's that documented? If not, uh, isn't that a somewhat serious bug
> > in gist?
>
> Thank you for pointing! This looks like a bug for me too. I'm going
> to investigate more on this and provide a fix in next couple of days.

Sorry for delay. Attached patch implements conflict handling for gist
microvacuum like btree and hash. I'm going to push it if no
objections.

Note, that it implements new WAL record type. So, new WAL can\t be
replayed on old minor release. I'm note sure if we claim that it's
usually possible. Should we state something explicitly for this case?

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

Attachment Content-Type Size
gist-microvacuum-conflict-handling.patch application/octet-stream 17.8 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2018-12-16 22:07:35 Re: Should new partitions inherit their tablespace from their parent?
Previous Message Andres Freund 2018-12-16 21:48:00 Re: Valgrind failures in Apply Launcher's bgworker_quickdie() exit