Re: Skip partition tuple routing with constant partition key

From: Andres Freund <andres(at)anarazel(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Tomas Vondra <tomas(dot)vondra(at)postgresql(dot)org>
Cc: Amit Langote <amitlangote09(at)gmail(dot)com>, Greg Stark <stark(at)mit(dot)edu>, Zhihong Yu <zyu(at)yugabyte(dot)com>, "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, "tsunakawa(dot)takay(at)fujitsu(dot)com" <tsunakawa(dot)takay(at)fujitsu(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Subject: Re: Skip partition tuple routing with constant partition key
Date: 2022-04-07 07:37:29
Message-ID: 20220407073729.5d3kgkvwsbhzjh65@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On 2022-04-06 00:07:07 -0400, Tom Lane wrote:
> Amit Langote <amitlangote09(at)gmail(dot)com> writes:
> > On Sun, Apr 3, 2022 at 10:31 PM Greg Stark <stark(at)mit(dot)edu> wrote:
> >> Is this a problem with the patch or its tests?
> >> [18:14:20.798] Test Summary Report
> >> [18:14:20.798] -------------------
> >> [18:14:20.798] t/013_partition.pl (Wstat: 15360 Tests: 31 Failed: 0)
>
> > Hmm, make check-world passes for me after rebasing the patch (v10) to
> > the latest HEAD (clean), nor do I see a failure on cfbot:
> > http://cfbot.cputube.org/amit-langote.html
>
> 013_partition.pl has been failing regularly in the buildfarm,
> most recently here:
>
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=florican&dt=2022-03-31%2000%3A49%3A45

Just failed locally on my machine as well.

> I don't think there's room to blame any uncommitted patches
> for that. Somebody broke it a short time before here:
>
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=wrasse&dt=2022-03-17%2016%3A08%3A19

The obvious thing to point a finger at is

commit c91f71b9dc91ef95e1d50d6d782f477258374fc6
Author: Tomas Vondra <tomas(dot)vondra(at)postgresql(dot)org>
Date: 2022-03-16 16:42:47 +0100

Fix publish_as_relid with multiple publications

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gunnar "Nick" Bluth 2022-04-07 07:43:22 Re: [PATCH] pg_stat_toast
Previous Message Michael Paquier 2022-04-07 07:36:32 Re: Add last commit LSN to pg_last_committed_xact()