Re: [GENERAL] hash taboo? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [GENERAL] hash taboo?
Date
Msg-id 199912180356.WAA06915@candle.pha.pa.us
Whole thread Raw
In response to Re: [GENERAL] hash taboo?  (admin <admin@wtbwts.com>)
List 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 by date:

Previous
From: admin
Date:
Subject: Re: [GENERAL] hash taboo?
Next
From: Ed Loehr
Date:
Subject: Re: [GENERAL] query buffer max length of 16384 exceeded