From: Tom Lane <tgl@sss.pgh.pa.us>
To: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Cc: Joe Conway <mail@joeconway.com>
Cc: David Rowley <david.rowley@2ndquadrant.com>
Cc: Andreas Seltenreich <andreas.seltenreich@credativ.de>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: Excessive memory usage in multi-statement queries w/ partitioning
Date: Mon, 27 May 2019 08:56:29 -0400
Message-ID: <65092.1558961789@sss.pgh.pa.us> (raw)
In-Reply-To: <3ed13306-ba63-f2e8-1eeb-63b0e4f377e6@lab.ntt.co.jp>
References: <87ftp6l2qr.fsf@credativ.de>
<e0ec915a-ebd3-ee9d-144b-e24bc3fae3c4@lab.ntt.co.jp>
<0e717312-3a02-781b-7dfc-e0cc395e92d8@joeconway.com>
<CAKJS1f-StHT8ZKyC8rsK=nJim13qDWDiNO8NMirTBo_jk=z5Aw@mail.gmail.com>
<db7efe35-03eb-e715-9766-d564dc479f0b@joeconway.com>
<6014.1558708103@sss.pgh.pa.us>
<3ed13306-ba63-f2e8-1eeb-63b0e4f377e6@lab.ntt.co.jp>
Amit Langote <Langote_Amit_f8@lab.ntt.co.jp> writes:
> On 2019/05/24 23:28, Tom Lane wrote:
>> So my thought, if we want to do something about this, is not "find
>> some things we can pfree at the end of planning" but "find a way
>> to use a separate context for each statement in the query string".
> Maybe like the attached? I'm not sure if we need to likewise be concerned
> about exec_sql_string() being handed multi-query strings.
Please add this to the upcoming CF so we don't forget about it.
(I don't think there's anything very new about this behavior, so
I don't feel that we should consider it an open item for v12 ---
anyone think differently?)
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, Langote_Amit_f8@lab.ntt.co.jp, mail@joeconway.com, david.rowley@2ndquadrant.com, andreas.seltenreich@credativ.de, pgsql-hackers@lists.postgresql.org
Subject: Re: Excessive memory usage in multi-statement queries w/ partitioning
In-Reply-To: <65092.1558961789@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox