Re: [HACKERS] from_collapse_limit considerations

2014-10-22 Thread Antonin Houska
[ I think I responded earlier but don't see my mail in the archive... ] Tom Lane wrote: > Antonin Houska writes: > > I noticed that - unlike join_collapse_limit - the from_collapse_limit does > > not > > enforce maximum length of the top-level list. Shouldn't it do? > > How would it do that? Y

Re: [HACKERS] from_collapse_limit considerations

2014-09-22 Thread Tom Lane
Antonin Houska writes: > I noticed that - unlike join_collapse_limit - the from_collapse_limit does not > enforce maximum length of the top-level list. Shouldn't it do? How would it do that? You want it to fail outright if there are more than N tables? That seems unhelpful. > Also, the order o

[HACKERS] from_collapse_limit considerations

2014-09-22 Thread Antonin Houska
While doing experiments with rather long FROM-lists, I looked closely at the logic related to from_collapse_limit. I noticed that - unlike join_collapse_limit - the from_collapse_limit does not enforce maximum length of the top-level list. Shouldn't it do? Too long FROM-list can obviously lead to