pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: 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: Tue, 17 Mar 2020 09:48:59 -0400
Message-ID: <31331.1584452939@sss.pgh.pa.us> (raw)
In-Reply-To: <CA+TgmoZoqQvYD5TmyzQGHw2HxmugLJ18j0wNPOJ9yUqYc=iy7g@mail.gmail.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>

Robert Haas <robertmhaas@gmail.com> writes:
> On Sun, Mar 15, 2020 at 10:38 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Well, if we say "PG can handle up to 64K relations in a query",
>> I think people would read that as meaning that you actually get
>> usable performance with up to 64K relations.  Which is a long
>> way away, even if certain specific cases might work acceptably.
>> The existing docs discourage using more than a few thousand
>> partitions, IIRC, and that seems like sufficient guidance for now.

> Would would be the downside to raising INNER_VAR to, say, a billion?

We'd have to widen AttrNumber to int32 and find all the places that
assume it's only 16 bits.  (Good luck with testing your way to having
any confidence in having found them all, so I'm not sure exactly how
to acquire such confidence.)  Maybe someday that will be a profitable
use of developer effort, but I have to say that I think that day is
a long way off.

			regards, tom lane





view thread (12+ messages)  latest in thread

Message-ID: <31331.1584452939@sss.pgh.pa.us>
Permalink:  ../31331.1584452939@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/31331.1584452939@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-bugs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, robertmhaas@gmail.com, amitlangote09@gmail.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: BUG #16302: too many range table entries - when count partition table(65538 childs)
  In-Reply-To: <31331.1584452939@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