Re: [PATCH] Infinite loop while acquiring new TOAST Oid

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [PATCH] Infinite loop while acquiring new TOAST Oid
Дата
Msg-id 20221128221009.hthgdia2yihq2cyt@awork3.anarazel.de
обсуждение исходный текст
Ответ на Re: [PATCH] Infinite loop while acquiring new TOAST Oid  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [PATCH] Infinite loop while acquiring new TOAST Oid
Re: [PATCH] Infinite loop while acquiring new TOAST Oid
Список pgsql-hackers
Hi,

On 2022-11-28 16:57:53 -0500, Tom Lane wrote:
> As I said before, I think there's a decent argument that some people
> will want the option to stay with 4-byte TOAST OIDs indefinitely,
> at least for smaller tables.

I think we'll need to do something about the width of varatt_external to make
the conversion to 64bit toast oids viable - and if we do, I don't think
there's a decent argument for staying with 4 byte toast OIDs. I think the
varatt_external equivalent would end up being smaller in just about all cases.
And as you said earlier, the increased overhead inside the toast table / index
is not relevant compared to the size of toasted datums.

Greetings,

Andres Freund



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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Add 64-bit XIDs into PostgreSQL 15
Следующее
От: Nikita Malakhov
Дата:
Сообщение: Re: [PATCH] Infinite loop while acquiring new TOAST Oid