Re: Increase value of OUTER_VAR

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Increase value of OUTER_VAR
Дата
Msg-id CAApHDvo4PO+4SosbVSH6XwFwrRZxMfMEB9G7kczOMSJpL0UJJg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Increase value of OUTER_VAR  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Increase value of OUTER_VAR
Список pgsql-hackers
On Sat, 3 Jul 2021 at 06:23, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> So I'm inclined to propose pushing this and seeing what happens.

Is this really sane?

As much as I would like to see the 65k limit removed, I just have
reservations about fixing it in this way.  Even if we get all the
cases fixed in core, there's likely a whole bunch of extensions
that'll have bugs as a result of this for many years to come.

"git grep \sIndex\s -- *.[ch] | wc -l" is showing me 77 matches in the
Citus code.  That's not the only extension that uses the planner hook.

I'm really just not sure it's worth all the dev hours fixing the
fallout.  To me, it seems much safer to jump bump 65k up to 1m. It'll
be a while before anyone complains about that.

It's also not that great to see the number of locations that you
needed to add run-time checks for negative varnos. That's not going to
come for free.

David



В списке pgsql-hackers по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: ATTACH PARTITION locking documentation for DEFAULT partitions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Reducing the cycle time for CLOBBER_CACHE_ALWAYS buildfarm members