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