Re: Query Analyzing

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

In response to

Browse pgsql-general by date

  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