Re: [PERFORM] Yet another abort-early plan disaster on 9.3

2014-10-19 Thread Greg Stark
On Sat, Oct 18, 2014 at 6:01 PM, Tomas Vondra wrote: > Hmmm. I have 0 experience with handling patents and related issues. Any > idea how to address that? Well there's no real way to address it. But to summarize: 1) We should not go searching for patents, knowing that something is patented incre

Re: [PERFORM] IS NOT NULL and LEFT JOIN

2014-10-19 Thread David Rowley
On Sun, Oct 19, 2014 at 5:10 PM, Laurent Martelli < laurent.marte...@enercoop.org> wrote: > Hello there, > > I have a strange query plan involving an IS NOT NULL and a LEFT JOIN. > > I grant you that the query can be written without the JOIN on > user_user_info, > but it is generated like this by