| From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) |
| Cc: | molivier(at)yahoo(dot)com, pgsql-sql(at)hub(dot)org |
| Subject: | Re: [SQL] Re: questions on interpreting the output of explain\ |
| Date: | 1999-02-21 21:23:58 |
| Message-ID: | 199902212123.QAA25946@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Excellent analysis. I will find a way to add this into the documenation
somewhere.
> Michael Olivier <molivier(at)yahoo(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | George Henry C. Daswani | 1999-02-21 22:33:09 | HAVING confusion.. |
| Previous Message | Tom Lane | 1999-02-21 20:36:23 | Re: questions on interpreting the output of explain |