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
signature.asc
Description: PGP signature
