Indexes

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@gmx.net http://funkturm.homeip.net/~peter

This might be a good starting point from which to RTFM

http://postgresql.readysetnet.com/users-lounge/docs/7.1/user/indices-types.h
tml

Documentation is your friend.... Say it with me -- documentation in your
friend :-)

-Mitch

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

On Wed, 30 May 2001, Peter Eisentraut wrote:

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

RTFM@http://postgresql.readysetnet.com/users-lounge/docs/7.1/postgres/indices-types.html

cheers,
t.