Re: Query slows when used with view - Mailing list pgsql-performance

From Michael Lewis
Subject Re: Query slows when used with view
Date
Msg-id CAHOFxGqD0HUg9p4JX2pTZyUNG8yO5NfeozPXKNY8wsEGN3U33w@mail.gmail.com
Whole thread Raw
In response to Re: Query slows when used with view  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Those are not equivalent queries.  Read up on the syntax of FROM;
particularly, that JOIN binds more tightly than comma.

I see this-

"A JOIN clause combines two FROM items, which for convenience we will refer to as “tables”, though in reality they can be any type of FROM item. Use parentheses if necessary to determine the order of nesting. In the absence of parentheses, JOINs nest left-to-right. In any case JOIN binds more tightly than the commas separating FROM-list items."

What is meant by nesting? Or binding for that matter? I wouldn't expect increasing from/join_collapse_limit to be helpful to the original poster since they haven't exceeded default limit of 8. Any further clarification elsewhere you could point to?

pgsql-performance by date:

Previous
From: Yavuz Selim Sertoğlu (ETIYA)
Date:
Subject: RE: Query slows when used with view
Next
From: Jeff Janes
Date:
Subject: Re: Query slows when used with view