Re: Postgres not using correct indices for views.

2019-08-10 Thread michael...@sqlexec.com
What a nice catch! Sent from my iPad On Aug 10, 2019, at 6:05 AM, Thomas Rosenstein wrote: >> [ re-adding list ] >> >> "Thomas Rosenstein" writes: On 9 Aug 2019, at 0:45, Tom Lane wrote: However ... it sort of looks like the planner didn't even consider the second plan shape i

Re: Postgres not using correct indices for views.

2019-08-10 Thread Thomas Rosenstein
[ re-adding list ] "Thomas Rosenstein" writes: On 9 Aug 2019, at 0:45, Tom Lane wrote: However ... it sort of looks like the planner didn't even consider the second plan shape in the "wrong" case. If it had, then even if it costed it 3X more than it did in the "right" case, the second plan wo