On Wed, Dec 14, 2022 at 12:03 PM Rick Otten wrote:
> Assuming I can live with the slower inserts, is there any parameter in
> particular I can tweak that would make the time it takes to create the hash
> index closer to the btree index creation time? In particular if I wanted to
> try this on
I inherited a database with several single-digit billion row tables. Those
tables have a varchar(36) column populated with uuids (all connected to
each other via FKs) each currently supported by a btree index.
After the recent conversations about hash indexes I thought I'd do some
comparisons to
