On Wed, Oct 13, 2021 at 12:15 PM Peter Geoghegan <p...@bowt.ie> wrote: > Are you sure? I know that nbtree index tuples for a single-column int8 > index are exactly the same size as those from a single column int4 > index, due to alignment overhead at the tuple level. So my guess is > that hash index tuples (which use the same basic IndexTuple > representation) work in the same way.
I'm assuming a 64-bit architecture here, by the way. That assumption shouldn't matter, since of course approximately 100% of all computers that run Postgres are 64-bit these days. -- Peter Geoghegan