To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
From: Andrey Lepikhov <a.lepikhov@postgrespro.ru>
Subject: Increase value of OUTER_VAR
Organization: Postgres Professional
Message-ID: <43c7f2f5-1e27-27aa-8c65-c91859d15190@postgrespro.ru>
Date: Wed, 3 Mar 2021 11:29:12 +0300
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.16; rv:78.0)
 Gecko/20100101 Thunderbird/78.8.0
MIME-Version: 1.0
Content-Type: multipart/mixed;
 boundary="------------E16825C64C686E3EFC762CCA"
Content-Language: en-US
Precedence: bulk

This is a multi-part message in MIME format.
--------------E16825C64C686E3EFC762CCA
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi,

Playing with a large value of partitions I caught the limit with 65000 
table entries in a query plan:

if (IS_SPECIAL_VARNO(list_length(glob->finalrtable)))
	ereport(ERROR,
		(errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED),
		errmsg("too many range table entries")));

Postgres works well with so many partitions.
The constants INNER_VAR, OUTER_VAR, INDEX_VAR are used as values of the 
variable 'var->varno' of integer type. As I see, they were introduced 
with commit 1054097464 authored by Marc G. Fournier, in 1996.
Value 65000 was relevant to the size of the int type at that time.

Maybe we will change these values to INT_MAX? (See the patch in attachment).

-- 
regards,
Andrey Lepikhov
Postgres Professional

--------------E16825C64C686E3EFC762CCA
Content-Type: text/plain; charset=UTF-8; x-mac-type="0"; x-mac-creator="0";
 name="0001-Set-values-of-special-varnos-to-the-upper-bound-of-t.patch"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
 filename*0="0001-Set-values-of-special-varnos-to-the-upper-bound-of-t.pa";
 filename*1="tch"

RnJvbSA5OGRhNzdjZGVmZDUzZGJmNGNlMGM3NDBkMWEwZjM1NmRhOTcwNjQ4IE1vbiBTZXAg
MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiAiQW5kcmV5IFYuIExlcGlraG92IiA8YS5sZXBpa2hv
dkBwb3N0Z3Jlc3Byby5ydT4KRGF0ZTogV2VkLCAzIE1hciAyMDIxIDExOjIyOjMyICswMzAw
ClN1YmplY3Q6IFtQQVRDSF0gU2V0IHZhbHVlcyBvZiBzcGVjaWFsIHZhcm5vcyB0byB0aGUg
dXBwZXIgYm91bmQgb2YgdGhlIGludAogdHlwZQoKLS0tCiBzcmMvaW5jbHVkZS9ub2Rlcy9w
cmltbm9kZXMuaCB8IDYgKysrLS0tCiAxIGZpbGUgY2hhbmdlZCwgMyBpbnNlcnRpb25zKCsp
LCAzIGRlbGV0aW9ucygtKQoKZGlmZiAtLWdpdCBhL3NyYy9pbmNsdWRlL25vZGVzL3ByaW1u
b2Rlcy5oIGIvc3JjL2luY2x1ZGUvbm9kZXMvcHJpbW5vZGVzLmgKaW5kZXggZDRjZTAzNzA4
OC4uOTAzOGQ5Nzg4NiAxMDA2NDQKLS0tIGEvc3JjL2luY2x1ZGUvbm9kZXMvcHJpbW5vZGVz
LmgKKysrIGIvc3JjL2luY2x1ZGUvbm9kZXMvcHJpbW5vZGVzLmgKQEAgLTE2OCw5ICsxNjgs
OSBAQCB0eXBlZGVmIHN0cnVjdCBFeHByCiAgKiBpbiB0aGUgcGxhbm5lciBhbmQgZG9lc24n
dCBjb3JyZXNwb25kIHRvIGFueSBzaW1wbGUgcmVsYXRpb24gY29sdW1uIG1heQogICogaGF2
ZSB2YXJub3N5biA9IHZhcmF0dG5vc3luID0gMC4KICAqLwotI2RlZmluZSAgICBJTk5FUl9W
QVIJCTY1MDAwCS8qIHJlZmVyZW5jZSB0byBpbm5lciBzdWJwbGFuICovCi0jZGVmaW5lICAg
IE9VVEVSX1ZBUgkJNjUwMDEJLyogcmVmZXJlbmNlIHRvIG91dGVyIHN1YnBsYW4gKi8KLSNk
ZWZpbmUgICAgSU5ERVhfVkFSCQk2NTAwMgkvKiByZWZlcmVuY2UgdG8gaW5kZXggY29sdW1u
ICovCisjZGVmaW5lICAgIElOTkVSX1ZBUgkJKElOVF9NQVggLSAyKQkvKiByZWZlcmVuY2Ug
dG8gaW5uZXIgc3VicGxhbiAqLworI2RlZmluZSAgICBPVVRFUl9WQVIJCShJTlRfTUFYIC0g
MSkJLyogcmVmZXJlbmNlIHRvIG91dGVyIHN1YnBsYW4gKi8KKyNkZWZpbmUgICAgSU5ERVhf
VkFSCQkoSU5UX01BWCkJLyogcmVmZXJlbmNlIHRvIGluZGV4IGNvbHVtbiAqLwogCiAjZGVm
aW5lIElTX1NQRUNJQUxfVkFSTk8odmFybm8pCQkoKHZhcm5vKSA+PSBJTk5FUl9WQVIpCiAK
LS0gCjIuMjkuMgoK
--------------E16825C64C686E3EFC762CCA--