Re: Next Steps with Hash Indexes - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Next Steps with Hash Indexes
Date
Msg-id CAH2-WzkHT7Hu0M6u5dgyG3GfuzDca+QBRO=+yVmqfdBeGq-QQA@mail.gmail.com
Whole thread Raw
In response to Re: Next Steps with Hash Indexes  (Peter Geoghegan <pg@bowt.ie>)
List pgsql-hackers
On Wed, Oct 13, 2021 at 12:15 PM Peter Geoghegan <pg@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



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Next Steps with Hash Indexes
Next
From: Tom Lane
Date:
Subject: Re: AW: VS2022: Support Visual Studio 2022 on Windows