Re: regression in PG 15.1 - Mailing list pgsql-admin

From Scott Ribe
Subject Re: regression in PG 15.1
Date
Msg-id 4B29C00C-028D-43AE-98F8-793BFC461CA5@elevated-dev.com
Whole thread Raw
In response to Re: regression in PG 15.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: regression in PG 15.1
List pgsql-admin
> On Nov 28, 2022, at 7:44 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Why do you say this is a regression?  From what I know of the partition
> pruning logic (admittedly not a whole lot), I don't think we'd have
> ever pruned on the basis of such a constraint.

Because performance of the query tanked. If it's not a change in table pruning, then it's a change in whether/how/which
indexesare used. I guess I'll have to dig into it more and get back to the list--probably tomorrow. 

Meantime, thanks for the clue to help guide me here.




pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: regression in PG 15.1
Next
From: Tom Lane
Date:
Subject: Re: regression in PG 15.1