got "too many range table entries" error when I tried to run a query on the table having more than 65,000 partitions. #PostgreSQL
-
-
Replying to @fujii_masao
Wow! I guess INNER_VAR (65000) and friends are entirely arbitrary and could be set to much larger numbers, since varno variables are of type int?
1 reply 0 retweets 1 like -
Replying to @MengTangmu @fujii_masao
Suspect it used to be a 16bit variable at some point, then the choice makes more sense. I'd not be entirely confident there's not parts that still assume that...
1 reply 0 retweets 0 likes -
It seems that it's always been an Index (unsigned int) type variable.
1 reply 0 retweets 0 likes
There's a fair bit of stuff in postgres that only explained with pre PGDG development in mind ;)
0 replies
1 retweet
2 likes
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.