Re: [PATCH] Infinite loop while acquiring new TOAST Oid - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [PATCH] Infinite loop while acquiring new TOAST Oid
Date
Msg-id 20221128221009.hthgdia2yihq2cyt@awork3.anarazel.de
Whole thread Raw
In response to Re: [PATCH] Infinite loop while acquiring new TOAST Oid  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PATCH] Infinite loop while acquiring new TOAST Oid
Re: [PATCH] Infinite loop while acquiring new TOAST Oid
List 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 by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Add 64-bit XIDs into PostgreSQL 15
Next
From: Nikita Malakhov
Date:
Subject: Re: [PATCH] Infinite loop while acquiring new TOAST Oid