Re: Early WIP/PoC for inlining CTEs

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Early WIP/PoC for inlining CTEs
Дата
Msg-id
744.1548602515@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Early WIP/PoC for inlining CTEs Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Early WIP/PoC for inlining CTEs David Fetter <david@fetter.org>
Re: Early WIP/PoC for inlining CTEs Nico Williams <nico@cryptonector.com>
Re: Early WIP/PoC for inlining CTEs Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Early WIP/PoC for inlining CTEs Nico Williams <nico@cryptonector.com>
Re: Early WIP/PoC for inlining CTEs Andreas Karlsson <andreas@proxel.se>
Re: Early WIP/PoC for inlining CTEs David Fetter <david@fetter.org>
Re: Early WIP/PoC for inlining CTEs Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Early WIP/PoC for inlining CTEs Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Early WIP/PoC for inlining CTEs David Fetter <david@fetter.org>
Re: Early WIP/PoC for inlining CTEs Thomas Munro <thomas.munro@enterprisedb.com>
Re: Early WIP/PoC for inlining CTEs David Fetter <david@fetter.org>
Re: Early WIP/PoC for inlining CTEs Thomas Munro <thomas.munro@enterprisedb.com>
Re: Early WIP/PoC for inlining CTEs Andres Freund <andres@anarazel.de>
Re: Early WIP/PoC for inlining CTEs Tatsuo Ishii <ishii@sraoss.co.jp>
Re: Early WIP/PoC for inlining CTEs Andreas Karlsson <andreas@proxel.se>
Re: Early WIP/PoC for inlining CTEs Andreas Karlsson <andreas@proxel.se>
Re: Early WIP/PoC for inlining CTEs David Fetter <david@fetter.org>
Re: Early WIP/PoC for inlining CTEs Andreas Karlsson <andreas@proxel.se>
Re: Early WIP/PoC for inlining CTEs David Fetter <david@fetter.org>
Re: Early WIP/PoC for inlining CTEs Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Early WIP/PoC for inlining CTEs David Fetter <david@fetter.org>
Re: Early WIP/PoC for inlining CTEs Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs David Fetter <david@fetter.org>
Re: Early WIP/PoC for inlining CTEs Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs Stephen Frost <sfrost@snowman.net>
Re: Early WIP/PoC for inlining CTEs Craig Ringer <craig@2ndquadrant.com>
Re: Early WIP/PoC for inlining CTEs Andreas Karlsson <andreas@proxel.se>
Re: Early WIP/PoC for inlining CTEs Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Early WIP/PoC for inlining CTEs Andreas Karlsson <andreas@proxel.se>
Re: Early WIP/PoC for inlining CTEs Andreas Karlsson <andreas@proxel.se>
Re: Early WIP/PoC for inlining CTEs Andreas Karlsson <andreas@proxel.se>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs Andreas Karlsson <andreas@proxel.se>
Re: Early WIP/PoC for inlining CTEs Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs Andreas Karlsson <andreas@proxel.se>
Re: Early WIP/PoC for inlining CTEs Robert Haas <robertmhaas@gmail.com>
Re: Early WIP/PoC for inlining CTEs Marko Tiikkaja <marko@joh.to>
Re: Early WIP/PoC for inlining CTEs Thomas Munro <thomas.munro@enterprisedb.com>
Re: Early WIP/PoC for inlining CTEs Robert Haas <robertmhaas@gmail.com>
Re: Early WIP/PoC for inlining CTEs Andres Freund <andres@anarazel.de>
Re: Early WIP/PoC for inlining CTEs Thomas Munro <thomas.munro@enterprisedb.com>
Re: Early WIP/PoC for inlining CTEs Andres Freund <andres@anarazel.de>
Re: Early WIP/PoC for inlining CTEs Robert Haas <robertmhaas@gmail.com>
Re: Early WIP/PoC for inlining CTEs Andreas Karlsson <andreas@proxel.se>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs Robert Haas <robertmhaas@gmail.com>
Re: Early WIP/PoC for inlining CTEs Andres Freund <andres@anarazel.de>
Re: Early WIP/PoC for inlining CTEs Robert Haas <robertmhaas@gmail.com>
Re: Early WIP/PoC for inlining CTEs Andreas Karlsson <andreas@proxel.se>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs Robert Haas <robertmhaas@gmail.com>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs Michael Paquier <michael@paquier.xyz>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs David Fetter <david@fetter.org>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs Bruce Momjian <bruce@momjian.us>
Re: Early WIP/PoC for inlining CTEs Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Early WIP/PoC for inlining CTEs Bruce Momjian <bruce@momjian.us>
Re: Early WIP/PoC for inlining CTEs Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs Andreas Karlsson <andreas@proxel.se>
Re: Early WIP/PoC for inlining CTEs Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Early WIP/PoC for inlining CTEs Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Early WIP/PoC for inlining CTEs Merlin Moncure <mmoncure@gmail.com>
Re: Early WIP/PoC for inlining CTEs Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Early WIP/PoC for inlining CTEs Andreas Karlsson <andreas@proxel.se>
Re: Early WIP/PoC for inlining CTEs Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Early WIP/PoC for inlining CTEs "Jonathan S. Katz" <jkatz@postgresql.org>
Sv: Re: Early WIP/PoC for inlining CTEs Andreas Joseph Krogh <andreas@visena.com>
Re: Early WIP/PoC for inlining CTEs Merlin Moncure <mmoncure@gmail.com>
Re: Early WIP/PoC for inlining CTEs Chapman Flack <chap@anastigmatix.net>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs Merlin Moncure <mmoncure@gmail.com>
Re: Early WIP/PoC for inlining CTEs Vik Fearing <vik.fearing@2ndquadrant.com>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs Andreas Karlsson <andreas@proxel.se>
Re: Early WIP/PoC for inlining CTEs Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: Early WIP/PoC for inlining CTEs Pavel Stehule <pavel.stehule@gmail.com>
Re: Early WIP/PoC for inlining CTEs Mike Rylander <mrylander@gmail.com>
Re: Early WIP/PoC for inlining CTEs David Fetter <david@fetter.org>
Re: Early WIP/PoC for inlining CTEs Robert Haas <robertmhaas@gmail.com>
Re: Early WIP/PoC for inlining CTEs Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Early WIP/PoC for inlining CTEs Andreas Karlsson <andreas@proxel.se>
Re: Early WIP/PoC for inlining CTEs Jeremy Finzel <finzelj@gmail.com>
Re: Early WIP/PoC for inlining CTEs Andres Freund <andres@anarazel.de>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs Andres Freund <andres@anarazel.de>
Re: Early WIP/PoC for inlining CTEs Tom Lane <tgl@sss.pgh.pa.us>
Re: Early WIP/PoC for inlining CTEs Andres Freund <andres@anarazel.de>
Re: Early WIP/PoC for inlining CTEs Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Early WIP/PoC for inlining CTEs Andres Freund <andres@anarazel.de>
Re: Early WIP/PoC for inlining CTEs Nico Williams <nico@cryptonector.com>
Re: Early WIP/PoC for inlining CTEs Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Early WIP/PoC for inlining CTEs Gavin Flower <GavinFlower@archidevsys.co.nz>
Re: Early WIP/PoC for inlining CTEs Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: Early WIP/PoC for inlining CTEs Merlin Moncure <mmoncure@gmail.com>
Andrew Gierth  writes:
> I'm not sure we should nail down the rule that the absence of NOT
> MATERIALIZED will mean a multiply-referenced CTE is evaluated once. One
> would hope that in the future the planner might be taught to inline or
> not in that case depending on cost. I think it makes more sense to say
> that we never inline if MATERIALIZED is specified, that we always inline
> if NOT MATERIALIZED is specified, and that if neither is specified the
> planner will choose (but perhaps note that currently it always chooses
> only based on refcount).

I have no objection to documenting it like that; I just don't want us
to go off into the weeds trying to actually implement something smarter
for v12.

			regards, tom lane

В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Dmitry Dolgov
Дата:
Сообщение: Re: Index Skip Scan
FAQ