Re: why choosing an hash index instead of the btree version even if the cost is lower?

Поиск
Список
Период
Сортировка
От Luca Ferrari
Тема Re: why choosing an hash index instead of the btree version even if the cost is lower?
Дата
Msg-id CAKoxK+71YQA3GM8iXSkVZnofBq1tpdz-LprMOdZcs+jk7Nrhmg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: why choosing an hash index instead of the btree version even if the cost is lower?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: Luca Ferrari
Дата:
Сообщение: Re: why choosing an hash index instead of the btree version even if the cost is lower?
Следующее
От: Sengottaiyan T
Дата:
Сообщение: Need suggestion to set-up RDS alerts on GP3 volumes