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

2024-11-02 Thread Andrei Lepikhov
On 3/11/2024 03:21, Vijaykumar Jain wrote: On Fri, 1 Nov 2024 at 18:51, Stepan Yankevych wrote: Partition pruning is not pushing predicate into dependent table during join in some cases. See example. Predicate highlighted in red i think your observation is correct. you may need to provide

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

2024-11-02 Thread Vijaykumar Jain
On Fri, 1 Nov 2024 at 18:51, Stepan Yankevych wrote: > > Partition pruning is not pushing predicate into dependent table during join > in some cases. > See example. Predicate highlighted in red > i think your observation is correct. you may need to provide redundant predicates for join both tabl