| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Justin Clift <justin(at)postgresql(dot)org>, PostgreSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Do we still have locking problems with concurrent users |
| Date: | 2002-03-06 03:17:53 |
| Message-ID: | 200203060317.g263Hr722602@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Christopher Kings-Lynne wrote:
> > It has not been fixed. One TODO item is to either stop mentioning hash
> > at all or get it improved. We have been sitting on the fence for too
> > long.
>
> Could someone give me a quick rundown on where using a hash index would be
> advantageous over using a btree index?
That is the issue, right now, there is little or no advantage. If we
can improve it, it may become better than btree for cases where you are
only doing equal comparisons, rather than > which only btree can do.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Lockhart | 2002-03-06 04:07:46 | Re: ext2 vs ext3 vs RAID5 (software) benchmark |
| Previous Message | Justin Clift | 2002-03-06 03:17:24 | Re: Do we still have locking problems with concurrentusers |