[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] Re: questions on interpreting the output of explain\
From:       Bruce Momjian <maillist () candle ! pha ! pa ! us>
Date:       1999-02-21 21:23:58
[Download RAW message or body]

Excellent analysis.  I will find a way to add this into the documenation
somewhere.


> Michael Olivier <molivier@yahoo.com> writes:
> > Can someone explain the details here to me? I guess specific questions
> > are:
> > - - Does hash join mean my acctname indexes are hashed, not btree'd? 
> > - - What does index scan mean?
> > - - Nested loop?
> 
> OK, I'll take a cut at this.  (I've been studying the Postgres optimizer
> lately, so I know a little bit about this, but I may be wrong about some
> of the details.)


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

[prev in list] [next in list] [prev in thread] [next in thread]