| From: | Patrick Giagnocavo <pgiagnoc(at)qi(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | rtree, btree, hash index methods...should I care? |
| Date: | 1998-09-16 18:19:31 |
| Message-ID: | 36000133.41FC0EC5@qi.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi Folks,
First let me just say that I am very positive about Postgres. I am
using it in conjunction with the AOLserver web server and am really glad
that it is so stable. It stays up for weeks at a time. I have never
had a crash or any data corruption.
Actual question:
Do I need to care about rtree/btree/hash methods? Is there a
performance difference in "normal" operations? What about when using 3
or 4 JOINs together?
Obviously the hash index is only useful for equals; and btree does seem
useful.
How much more of a "cost" is there in terms of inserts and updates if I
make 2 indexes (one btree, one rtree) on the same table?
./patrick
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerome Knobl | 1998-09-17 08:13:51 | Re: [SQL] How to Make Case InSensitive??? |
| Previous Message | Bruce Momjian | 1998-09-16 17:30:47 | Re: [SQL] How to Make Case InSensitive??? |