pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Amit Langote <amitlangote09@gmail.com>
Cc: digoal@126.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #16302: too many range table entries - when count partition table(65538 childs)
Date: Thu, 19 Mar 2020 09:33:36 -0400
Message-ID: <3515.1584624816@sss.pgh.pa.us> (raw)
In-Reply-To: <54912a3b-fec1-eb85-4971-46de1a1d0f5e@2ndquadrant.com>
References: <16302-e45634e2c0e34e97@postgresql.org>
	<32763.1584198185@sss.pgh.pa.us>
	<CA+HiwqFZRY=t9jzgbMq5aiKSLWsAj_XhycpULY_PY2W65_cLNw@mail.gmail.com>
	<28094.1584326310@sss.pgh.pa.us>
	<CA+TgmoZoqQvYD5TmyzQGHw2HxmugLJ18j0wNPOJ9yUqYc=iy7g@mail.gmail.com>
	<31331.1584452939@sss.pgh.pa.us>
	<CA+TgmoanuqV8bFRjGeWoNFNZfQJOwYq04DQ6gsLh5VzC-D2thw@mail.gmail.com>
	<1032.1584456128@sss.pgh.pa.us>
	<CA+TgmoaM2xy09C67OM8nUSAZU2Dn5E6nTJUko8pr0=fHu4Z84g@mail.gmail.com>
	<54912a3b-fec1-eb85-4971-46de1a1d0f5e@2ndquadrant.com>

Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:
> You could make INNER_VAR -1 and so on.  Then it would probably break 
> quite clearly if it's not signedness clean.

I kinda like this, because it'd avoid having random large constants
in the code.

We'd have to change Var.varno and some other places from Index to
plain int, or else invent a typedef --- but the number of places
currently using plain int for this sort of purpose is very large,
so probably a new typedef is not worth the hassle.

			regards, tom lane





view thread (12+ messages)  latest in thread

Message-ID: <3515.1584624816@sss.pgh.pa.us>
Permalink:  ../3515.1584624816@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/3515.1584624816@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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-bugs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, peter.eisentraut@2ndquadrant.com, robertmhaas@gmail.com, amitlangote09@gmail.com
  Subject: Re: BUG #16302: too many range table entries - when count partition table(65538 childs)
  In-Reply-To: <3515.1584624816@sss.pgh.pa.us>
  References: <16302-e45634e2c0e34e97@postgresql.org> <32763.1584198185@sss.pgh.pa.us> <CA+HiwqFZRY=t9jzgbMq5aiKSLWsAj_XhycpULY_PY2W65_cLNw@mail.gmail.com> <28094.1584326310@sss.pgh.pa.us> <CA+TgmoZoqQvYD5TmyzQGHw2HxmugLJ18j0wNPOJ9yUqYc=iy7g@mail.gmail.com> <31331.1584452939@sss.pgh.pa.us> <CA+TgmoanuqV8bFRjGeWoNFNZfQJOwYq04DQ6gsLh5VzC-D2thw@mail.gmail.com> <1032.1584456128@sss.pgh.pa.us> <CA+TgmoaM2xy09C67OM8nUSAZU2Dn5E6nTJUko8pr0=fHu4Z84g@mail.gmail.com> <54912a3b-fec1-eb85-4971-46de1a1d0f5e@2ndquadrant.com> <3515.1584624816@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