Re: CTE Inline On TPC-DS Query 95 - Mailing list pgsql-performance

From David Rowley
Subject Re: CTE Inline On TPC-DS Query 95
Date
Msg-id CAApHDvopLOxy+FSBmu3j6OaBivj7B-ycDQgUDVPfr__HVTsi=g@mail.gmail.com
Whole thread Raw
In response to RE: CTE Inline On TPC-DS Query 95  (<msalais@msym.fr>)
List pgsql-performance
On Sat, 28 Dec 2024 at 00:34, <msalais@msym.fr> wrote:
> Sometimes one is better and sometimes the other is best.
> In Oracle, the choice is done by COST. This should be the same for PostgreSQL. In essence, it is the same thing for
views:inlining or materializing...
 

I don't doubt you. However, I did already mention the cost part in the
final paragraph of my email and I also hinted on why it might be more
difficult than you might imagine to implement. I don't want to put
anyone off making improvements in this area. I only aim to highlight
that it's not trivial to do so.

David



pgsql-performance by date:

Previous
From:
Date:
Subject: RE: CTE Inline On TPC-DS Query 95
Next
From:
Date:
Subject: RE: Reg. Postgres Unique contraint