Re: Postgresql 14/15/16/17 partition pruning on dependent table during join

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

 



On 4/11/2024 15:23, Stepan Yankevych wrote:
Let's classify it as possible improvement / new feature for further releases. Optimizer definitely should be able to add that extra (redundant) condition *and e.exec_date_id >= 20241021*
or even transform* e.exec_date_id >= co.create_date_id *
to              *e.exec_date_id >= **20241021*
Not sure it would be easy (and make sense) to implement it as a core feature. But the idea of the extensibility of the clause deduction system looks spectacular to me.

--
regards, Andrei Lepikhov






[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux