Postgres Pro
Downloads
Home   >   mailing lists

Re: Parallel vacuum workers prevent the oldest xmin from advancing - Mailing list pgsql-hackers

From Greg Nancarrow
Subject Re: Parallel vacuum workers prevent the oldest xmin from advancing
Date
Msg-id CAJcOf-eHCEFjp7cqAPDpgcx3NkNMPtrXb-e9W3mdJ6FusqyYXg@mail.gmail.com
Whole thread Raw
In response to Parallel vacuum workers prevent the oldest xmin from advancing  (Masahiko Sawada <sawada.mshk@gmail.com>)
Responses Re: Parallel vacuum workers prevent the oldest xmin from advancing  (Masahiko Sawada <sawada.mshk@gmail.com>)
List pgsql-hackers
Tree view 
On Wed, Oct 6, 2021 at 6:11 PM Masahiko Sawada <sawada.mshk@gmail.com> wrote:
>
> To fix it, I thought that we change the create index code and the
> vacuum code so that the individual parallel worker sets its status
> flags according to the leader’s one. But ISTM it’d be better to copy
> the leader’s status flags to workers in ParallelWorkerMain(). I've
> attached a patch for HEAD.
>

+1 The fix looks reasonable to me too.
Is it possible for the patch to add test cases for the two identified
problem scenarios? (PROC_IN_VACUUM, PROC_IN_SAFE_IC)

Regards,
Greg Nancarrow
Fujitsu Australia

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Fix pg_log_backend_memory_contexts() 's delay
Next
From: Michael Paquier
Date:
Subject: Re: VS2022: Support Visual Studio 2022 on Windows