Hi David,
Thank you for your reply!
You mean when you change the date equality filter to a more recent date? - This
is correct we have faced this when we change equality filter to more recent
date.
Will be sending explain analyze on the thread when I get that.
We ran analyze many time to see if
On Tue, May 5, 2020 at 6:15 PM Virendra Kumar wrote:
> Optimizer is behaving little weird in the sense that for change in one
> filter
>
You mean when you change the date equality filter to a more recent date?
> it is using NESTED LOOP JOIN and running for over 30 seconds whereas for
> other f
Hi Everyone,
PG Version - RDS PostgreSQL 10.11
We have very simple query of 3 table joins and a few filter clause. Optimizer
is behaving little weird in the sense that for change in one filter it is using
NESTED LOOP JOIN and running for over 30 seconds whereas for other filter is
working fine u
