Re: regression in PG 15.1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> On Nov 28, 2022, at 7:44 AM, Tom Lane <tgl@xxxxxxxxxxxxx> 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 indexes are 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.







[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux