From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Manfred Koizar <mkoi-pg(at)aon(dot)at> |
Cc: | "Booth, Robert" <Robert_Booth(at)intuit(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Query Analyzing |
Date: | 2002-07-09 14:08:26 |
Message-ID: | 200207091408.g69E8Qd10091@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Manfred Koizar wrote:
> On Mon, 8 Jul 2002 11:16:34 -0700, "Booth, Robert"
> <Robert_Booth(at)intuit(dot)com> wrote:
> > [a lot of info I asked him to post]
>
> Rob, I have to look a this closer first. I'll be back ...
>
> >Again if there is somewhere I can go to read about explain plans let me know
> >I'd like to figure it out as opposed to getting the answers handed to me.
>
> For now, here is what I found:
>
> http://www.at.postgresql.org/users-lounge/docs/7.2/postgres/performance-tips.html
> http://www.postgresql.org/idocs/index.php?performance-tips.html#USING-EXPLAIN
>
> PostgreSQL: Introduction and Concepts by Bruce Momjian (online
> version)
> http://www.ca.postgresql.org/docs/aw_pgsql_book/node112.html
> http://www.ca.postgresql.org/docs/aw_pgsql_book/node251.html
>
> Practical PostgreSQL by John Worsley and Joshua Drake (online version)
> http://www.commandprompt.com/ppbook/
> http://www.commandprompt.com/ppbook/index.lxp?lxpwrap=r26943%2ehtm
Also:
http://developer.postgresql.org/pdf/internalpics.pdf
--
Bruce Momjian | http://candle.pha.pa.us
pgman(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 | Thomas Lockhart | 2002-07-09 14:20:19 | Re: Query Casting Help |
Previous Message | Carmen Wai | 2002-07-09 14:06:57 | LOAD command not updating the recompiled object code |