Postgres Pro
Downloads
Home   >   mailing lists

Re: why choosing an hash index instead of the btree version even if the cost is lower? - Mailing list pgsql-performance

From Luca Ferrari
Subject Re: why choosing an hash index instead of the btree version even if the cost is lower?
Date
Msg-id CAKoxK+71YQA3GM8iXSkVZnofBq1tpdz-LprMOdZcs+jk7Nrhmg@mail.gmail.com
Whole thread Raw
In response to Re: why choosing an hash index instead of the btree version even if the cost is lower?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
On Fri, Nov 18, 2022 at 3:55 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Even more to the point: if the total costs are fuzzily the same,
> then the next point of comparison will be the startup costs,
> which is where the hash index wins.

Thanks, it is clear now.

Luca

pgsql-performance by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: why choosing an hash index instead of the btree version even if the cost is lower?
Next
From: Sengottaiyan T
Date:
Subject: Need suggestion to set-up RDS alerts on GP3 volumes