Re: hyrax vs. RelationBuildPartitionDesc
От
Robert Haas
Тема
Re: hyrax vs. RelationBuildPartitionDesc
Дата
Msg-id
CA+Tgmoaci6KaV3dyQADosfHyCVHB-8XeYkXY7GFebH1a_7Zr5A@mail.gmail.com
Ответ на
Re: hyrax vs. RelationBuildPartitionDesc (Tom Lane)
Список
Дерево обсуждения
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 Wed, Mar 13, 2019 at 1:15 PM Tom Lane wrote: > I'm a bit confused as to why there's an issue here at all. The usual > plan for computed-on-demand relcache sub-structures is that we compute > a working copy that we're going to return to the caller using the > caller's context (which is presumably statement-duration at most) > and then do the equivalent of copyObject to stash a long-lived copy > into the relcache context. Is this case being done differently, and if > so why? If it's being done the same, where are we leaking? It's being done in just that way. The caller's context is MessageContext, which is indeed statement duration. But if you plunk 10k into MessageContext a few thousand times per statement, then you chew through a couple hundred meg of memory, and apparently hyrax can't tolerate that. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
В списке pgsql-hackers по дате отправления