Re: Support for 8-byte TOAST values, round two - Mailing list pgsql-hackers

In my insert tests 8-byte TOAST was much faster that 4-byte toast

During a 30 min run inserting tuples with 8  toasted fields of ~100
bytes oid8 toast kept a steady 18k inserts / second against 14.6k
inserts second for oid4

This resulted in a solid 23% speed-up because it didn't need to verify
new OIDs against the unique index, despite each toast index entry
taking up slightly more space (30.1 bytes vs. 21.4 bytes on average)







On Wed, Sep 23, 2026 at 12:58 PM Michael Paquier <michael@paquier.xyz> wrote:
>
> On Tue, Sep 22, 2026 at 03:35:00PM -0700, Bharath Rupireddy wrote:
> > Agreed. Using OID/OID8 values and breaking up the sentences reads
> > better. Please find the attached v2 patch.
>
> Pushed.
> --
> Michael