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 8905.1316043618@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Hash index use presently(?) discouraged since 2005: revive or bury it?  (Stefan Keller <sfkeller@gmail.com>)
Ответы Re: Hash index use presently(?) discouraged since 2005: revive or bury it?  (Tomas Vondra <tv@fuzzy.cz>)
Список pgsql-performance
Stefan Keller <sfkeller@gmail.com> writes:
> 2011/9/14 Tom Lane <tgl@sss.pgh.pa.us> writes:
>> (...) I think that
>> the current state of affairs is still what depesz said, namely that
>> there might be cases where they'd be a win to use, except the lack of
>> WAL support is a killer.  I imagine somebody will step up and do that
>> eventually.

> How much of work (in man days) do you estimate would this mean for
> someone who can program but has to learn PG internals first?

No idea ... I'm probably not the best person to estimate how long it
would take someone to get up to speed on the relevant internals,
but I'm sure that would take longer than actually doing the work.
While it's not a trivial task, I think it fits the definition of
"a small matter of programming": a piece of code whose anticipated
length is significantly greater than its complexity.

            regards, tom lane

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

Предыдущее
От: Stefan Keller
Дата:
Сообщение: Re: Hash index use presently(?) discouraged since 2005: revive or bury it?
Следующее
От: Carlo Stonebanks
Дата:
Сообщение: Re: Migrated from 8.3 to 9.0 - need to update config (re-post)