Thread: Indexes
Hello This may sound like a trivial question, but can someone explain me the difference between the types of access methods toindexes 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 goingto join tables, other if you will just query, etc... Thanks Aristide
Aristide Aragon writes: > This may sound like a trivial question, but can someone explain me the difference between the types of access methods toindexes 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 goingto 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... > > RTFM > > -- > Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter
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 methodsto 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'regoing 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. > > -- > Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl >