rtree, btree, hash index methods...should I care?

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: Raw Message | Whole Thread | 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

Browse pgsql-sql by date

  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???