On Sat, 28 Dec 2024 at 00:34, 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
: Re: CTE Inline On TPC-DS Query 95
On Tue, 26 Nov 2024 at 10:03, Ba Jinsheng wrote:
> If we specify ``NOT MATERIALIZED`` for the query, the execution time is
> reduced from 1min to 1s due to the usage of inline CTE. It seems expected as
> described in the PostgreSQL documentation. How
On Tue, 26 Nov 2024 at 10:03, Ba Jinsheng wrote:
> If we specify ``NOT MATERIALIZED`` for the query, the execution time is
> reduced from 1min to 1s due to the usage of inline CTE. It seems expected as
> described in the PostgreSQL documentation. However, from the code:
> https://github.com/pos
