Re: effective_wal_level is not decreasing after using REPACK (CONCURRENTLY)

From: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
To: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Cc: shveta malik <shveta(dot)malik(at)gmail(dot)com>, Imran Zaheer <imran(dot)zhir(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, shveta malik <shvetamalik(at)gmail(dot)com>
Subject: Re: effective_wal_level is not decreasing after using REPACK (CONCURRENTLY)
Date: 2026-05-27 18:56:07
Message-ID: CAD21AoBmdmBQ-+Jga+jSKKq5OPGEP1pEjSJfRPT6MCwVHLD6og@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, May 27, 2026 at 11:25 AM Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> wrote:
>
> On Wed, May 27, 2026 at 11:20 AM Álvaro Herrera <alvherre(at)kurilemu(dot)de> wrote:
> >
> > On 2026-May-26, shveta malik wrote:
> >
> > > On Tue, May 26, 2026 at 3:09 PM Imran Zaheer <imran(dot)zhir(at)gmail(dot)com> wrote:
> > > >
> > > > Hi,
> > > >
> > > > Thanks Shveta, I agree with the additional sanity checks and comments.
> > >
> > > Thanks, v3 LGTM.
> >
> > Thanks! Pushed with some cosmetic changes.
>
> Thank you for pushing the patch!

Some buildfarm members reported failures[1][2]. The newly added test
works only on builds without injection points because the logical slot
"test_slot" is removed during tests using injection points, otherwise
it still exists on the primary server at the end of
051_effective_wal_level.pl.

Regards,

[1] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=loach&dt=2026-05-27%2018%3A25%3A00
[2] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=goldfish&dt=2026-05-27%2018%3A15%3A02

--
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2026-05-27 19:08:34 Re: Is there value in having optimizer stats for joins/foreignkeys?
Previous Message Jim Jones 2026-05-27 18:29:18 Re: Add XMLNamespaces to XMLElement