Re: Early WIP/PoC for inlining CTEs
От
Tom Lane
Тема
Re: Early WIP/PoC for inlining CTEs
Дата
Msg-id
744.1548602515@sss.pgh.pa.us
Ответ на
Re: Early WIP/PoC for inlining CTEs (Andrew Gierth)
Список
Дерево обсуждения
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
Дата: