Re: Table order at FROM clause affects performance?

2018-04-12 Thread Eduard CatalĂ 
Yes... i can't exepct useful help with my poor explanation but your aproach is the right answer! We were limited with from_collapse_limit. Cost now is: 112 Many many thanks. On Thu, Apr 12, 2018 at 5:30 PM, Tom Lane wrote: > =?UTF-8?Q?Eduard_Catal=C3=A0?= writes: > > Given this statement

Re: Table order at FROM clause affects performance?

2018-04-12 Thread Tom Lane
=?UTF-8?Q?Eduard_Catal=C3=A0?= writes: > Given this statement: > SELECT *several_fields* FROM A, B, C WHERE *conditions* > A, B are tables with several LEFT JOINS but they act as one subquery. You really can't expect useful help if you are going to pose questions that abstract. You have remov

Table order at FROM clause affects performance?

2018-04-12 Thread Eduard CatalĂ 
I have a strange performance issue, i think that is not possible: Given this statement: SELECT *several_fields* FROM A, B, C WHERE *conditions* A, B are tables with several LEFT JOINS but they act as one subquery. If I execute the select above: SELECT *several_fields* FROM A, B, C WHERE *co