Re: [GENERAL] hash taboo?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [GENERAL] hash taboo?
Дата
Msg-id 199912180356.WAA06915@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] hash taboo?  (admin <admin@wtbwts.com>)
Список pgsql-general
> Excellent point, your last comment gives me a tangible incentive for using
> hash instead of btree. Since I don't need to use other operators than '=',
> there is really no need to spend extra time creating a btree while all I
> need is a hash table. In the end, both are as fast for searching, but I
> gain some additional speed for inserting and removing entries.

Is the hash faster to create?

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

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

Предыдущее
От: admin
Дата:
Сообщение: Re: [GENERAL] hash taboo?
Следующее
От: Ed Loehr
Дата:
Сообщение: Re: [GENERAL] query buffer max length of 16384 exceeded