Re: Hash index use presently(?) discouraged since 2005: revive or bury it?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Hash index use presently(?) discouraged since 2005: revive or bury it?
Дата
Msg-id 13742.1316126288@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Hash index use presently(?) discouraged since 2005: revive or bury it?  (Merlin Moncure <mmoncure@gmail.com>)
Ответы Re: Hash index use presently(?) discouraged since 2005: revive or bury it?  (Claudio Freire <klaussfreire@gmail.com>)
Re: Hash index use presently(?) discouraged since 2005: revive or bury it?  (Merlin Moncure <mmoncure@gmail.com>)
Re: Hash index use presently(?) discouraged since 2005: revive or bury it?  (Stefan Keller <sfkeller@gmail.com>)
Список pgsql-performance
Merlin Moncure <mmoncure@gmail.com> writes:
> HM, what if you junked the current hash indexam, and just implemented
> a wrapper over btree so that the 'hash index' was just short hand for
> hashing the value into a standard index?

Surely creating such a wrapper would be *more* work than adding WAL
support to the hash AM.

I'm not entirely following this eagerness to junk that AM, anyway.
We've put a lot of sweat into it over the years, in the hopes that
it would eventually be good for something.  It's on the edge of
being good for something now, and there's doubtless room for more
improvements, so why are the knives out?

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Hash index use presently(?) discouraged since 2005: revive or bury it?
Следующее
От: Claudio Freire
Дата:
Сообщение: Re: Hash index use presently(?) discouraged since 2005: revive or bury it?