Re: CTE Inline On TPC-DS Query 95

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: CTE Inline On TPC-DS Query 95
Дата
Msg-id CAApHDvopLOxy+FSBmu3j6OaBivj7B-ycDQgUDVPfr__HVTsi=g@mail.gmail.com
обсуждение исходный текст
Ответ на RE: CTE Inline On TPC-DS Query 95  (<msalais@msym.fr>)
Список 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 по дате отправления: