Re: Support for 8-byte TOAST values, round two

On Thu, Jul 30, 2026 at 01:16:36PM +0200, Hannu Krosing wrote:
> Have you compared the index sizes of OID and 8-byte ID ?

Please do not top-post. This breaks the logical flow of the community
thread. Please see the following about bottom-posting:
https://en.wikipedia.org/wiki/Posting_style#Bottom-posting

> It is possible, that they are of the same size because of alignment, so
> there would not be any difference in size.

I suspect that the size is the same due to 8-byte alignment (not done
a measurement on that with a fixed loading pattern). Just please note
that the OID8 behavior is available on an opt-in as a reloption, with
OID still being the default. So there is no impact by default,
neither is there an impact across upgrades. A relation set with an
OID8 is preserved across pg_upgrade moving forward to newer versions,
of course.
--
Michael