Re: hyrax vs. RelationBuildPartitionDesc
От
Alvaro Herrera
Тема
Re: hyrax vs. RelationBuildPartitionDesc
Дата
Msg-id
20190313182145.GA488@alvherre.pgsql
Ответ на
Re: hyrax vs. RelationBuildPartitionDesc (Robert Haas)
Список
Дерево обсуждения
hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Alvaro Herrera <alvherre@2ndquadrant.com>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Alvaro Herrera <alvherre@2ndquadrant.com>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Alvaro Herrera <alvherre@2ndquadrant.com>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: hyrax vs. RelationBuildPartitionDesc Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Michael Paquier <michael@paquier.xyz>
Re: hyrax vs. RelationBuildPartitionDesc Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: hyrax vs. RelationBuildPartitionDesc Michael Paquier <michael@paquier.xyz>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Amit Langote <amitlangote09@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Andres Freund <andres@anarazel.de>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Andres Freund <andres@anarazel.de>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Amit Langote <amitlangote09@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Heikki Linnakangas <hlinnaka@iki.fi>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Andres Freund <andres@anarazel.de>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Andres Freund <andres@anarazel.de>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Amit Langote <amitlangote09@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Amit Langote <amitlangote09@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Amit Langote <amitlangote09@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Tom Lane <tgl@sss.pgh.pa.us>
Re: hyrax vs. RelationBuildPartitionDesc Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: hyrax vs. RelationBuildPartitionDesc Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
Re: hyrax vs. RelationBuildPartitionDesc Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: hyrax vs. RelationBuildPartitionDesc Robert Haas <robertmhaas@gmail.com>
On 2019-Mar-13, Robert Haas wrote: > On Wed, Mar 13, 2019 at 1:38 PM Alvaro Herrera wrote: > > A bit, yes, but not overly so, and it's less fragile that not having > > such a protection. Anything that allocates in CacheMemoryContext needs > > to be very careful anyway. > > True, but I think it's more fragile than either of the options I proposed. You do? Unless I misunderstood, your options are: 1. (the patch you attached) create a temporary memory context that is used for everything, then at the end copy the good stuff to CacheMemCxt (or a sub-context thereof). This still needs to copy. 2. create a temp memory context, do everything there, do retail freeing of everything we don't want, reparenting the context to CacheMemCxt. Hope we didn't forget to pfree anything. How is any of those superior to what I propose? -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-hackers по дате отправления