pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Amit Langote <amitlangote09@gmail.com>
Cc: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: keisuke kuroda <keisuke.kuroda.3862@gmail.com>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Cc: tatsuhito.kasahara.rd@hco.ntt.co.jp
Subject: Re: Huge memory consumption on partitioned table with FKs
Date: Wed, 10 Mar 2021 14:24:57 -0500
Message-ID: <2187988.1615404297@sss.pgh.pa.us> (raw)
In-Reply-To: <CA+HiwqE7xvHBN3dm3ee2XU++tjuxHv5giyrmaE7McSeG6yPdoA@mail.gmail.com>
References: <20201203.142857.1823750032495295791.horikyota.ntt@gmail.com>
	<CA+HiwqEOrfN9b=f3sDmySPGc4gO-L_VMFHXLLxVmmdP34e64+w@mail.gmail.com>
	<CANDwggJcdu3Cbtr50X+zLXoh+rB-MYfp=GGqbfv8TVS3VT4tuA@mail.gmail.com>
	<20201204.144822.1258776940142794322.horikyota.ntt@gmail.com>
	<CA+HiwqGrr2YOO6voBM6m_OAc9w-WMxe1gOuQ-UyDPin6zJtyZw@mail.gmail.com>
	<1412267.1614891636@sss.pgh.pa.us>
	<CA+HiwqFbYQ+6xKyDJmb18+vHA1+KuF8VMXEtVO-Y68tTJow5CQ@mail.gmail.com>
	<2050317.1615333064@sss.pgh.pa.us>
	<CA+HiwqE7xvHBN3dm3ee2XU++tjuxHv5giyrmaE7McSeG6yPdoA@mail.gmail.com>

Amit Langote <amitlangote09@gmail.com> writes:
> On Wed, Mar 10, 2021 at 8:37 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Hmm.  So, the key point is that the values coming from the partitioned
>> child table are injected into the test query as parameters, not as
>> column references, thus it doesn't matter *to the test query* what
>> numbers the referencing columns have in that child.  We just have to
>> be sure we pass the right parameter values.

> Right.

I did some cosmetic fooling with this (mostly, rewriting the comments
YA time) and pushed it.

			regards, tom lane





view thread (53+ messages)  latest in thread

Message-ID: <2187988.1615404297@sss.pgh.pa.us>
Permalink:  ../2187988.1615404297@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/2187988.1615404297@sss.pgh.pa.us

 · 

reply
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, amitlangote09@gmail.com, horikyota.ntt@gmail.com, keisuke.kuroda.3862@gmail.com, alvherre@alvh.no-ip.org, tatsuro.yamada.tf@nttcom.co.jp, pgsql-hackers@lists.postgresql.org, tatsuhito.kasahara.rd@hco.ntt.co.jp
  Subject: Re: Huge memory consumption on partitioned table with FKs
  In-Reply-To: <2187988.1615404297@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