Horton

Re: Parallel vacuum workers prevent the oldest xmin from advancing

Amit Kapila <amit.kapila16@gmail.com>

View thread View on postgr.es
From: Amit Kapila <amit.kapila16@gmail.com>
To: Masahiko Sawada <sawada.mshk@gmail.com>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>, Andres Freund <andres@anarazel.de>, Michael Paquier <michael@paquier.xyz>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2021-11-17T11:27:42Z
Lists: pgsql-hackers 
On Wed, Nov 17, 2021 at 1:06 PM Masahiko Sawada <sawada.mshk@gmail.com> wrote:
>
> On Tue, Nov 16, 2021 at 8:45 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> The patch looks good to me. But I can't come up with a stable test for
> this. It seems to be hard without stopping and resuming parallel
> vacuum workers. Do you have any good idea?
>

No, let's wait for a day or so to see if anybody else has any ideas to
write a test for this case, otherwise, I'll check these once again and
push.

-- 
With Regards,
Amit Kapila.

Commits

  1. Fix parallel operations that prevent oldest xmin from advancing.