Re: Remove size limitations of vacuums dead_tuples array

Поиск
Список
Период
Сортировка
От Ants Aasma
Тема Re: Remove size limitations of vacuums dead_tuples array
Дата
Msg-id CANwKhkMK9YxZJo_NKBLyXgPcoB_5Fqmf3M=ev8jU19=UEHhtVw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Remove size limitations of vacuums dead_tuples array  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Ответы Re: Remove size limitations of vacuums dead_tuples array  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
Дерево обсуждения
On Thu, 10 Oct 2019 at 17:05, Tomas Vondra <tomas.vondra@2ndquadrant.com> wrote:
There already was a attempt to make this improvement, see [1]. There was
a fairly long discussion about how to best do that (using other data
structure, not just a simple array). It kinda died about a year ago, but
I suppose there's a lot of relevant info in that thread.

[1] https://www.postgresql.org/message-id/CAGTBQpbDCaR6vv9%3DscXzuT8fSbckf%3Da3NgZdWFWZbdVugVht6Q%40mail.gmail.com

Thanks for the pointer, wow that's a long thread. For some reason it did not consider lifting the INT_MAX tuples/12GB limitation. I'll see if I can pick up where that thread left off and push it along.

Regards,
Ants Aasma


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

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: let's make the list of reportable GUCs configurable (was Re: Add%r substitution for psql prompts to show recovery status)
Следующее
От: Konstantin Knizhnik
Дата:
Сообщение: Re: [Proposal] Global temporary tables