Re: Indexes

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Aristide Aragon <aristide(at)lionking(dot)org>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Indexes
Date: 2001-05-30 20:03:09
Message-ID: Pine.LNX.4.30.0105302202590.757-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Aristide Aragon writes:

> This may sound like a trivial question, but can someone explain me the difference between the types of access methods to indexes that PGSQL supports? I understand HASH, but not the others..
> if possible, can someone tell me what index is good for what type of situations? Like some index is better if you're going to join tables, other if you will just query, etc...

RTFM

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

  • Indexes at 2001-05-30 18:53:43 from Aristide Aragon

Responses

  • Re: Indexes at 2001-05-30 20:25:04 from Mitch Vincent
  • Re: Indexes at 2001-05-30 20:31:38 from Thalis A. Kalfigopoulos

Browse pgsql-general by date

  From Date Subject
Next Message Mitch Vincent 2001-05-30 20:25:04 Re: Indexes
Previous Message Tim Barnard 2001-05-30 19:49:20 Re: [SQL] Difficult SQL Statement