Thread: Cannot find slides dealing with EXPLAIN output

Cannot find slides dealing with EXPLAIN output

From
Alexey Borzov
Date:
Greetings!

Some time ago I've seen slides from some presentation about PostgreSQL
performance, those dealt not with the usual postgresql.conf tweaking but with
making sense out of the EXPLAIN command output.

Unfortunately I misplaced the link and cannot remember either the name of the
presentation or the names of the people who gave it. Can someone refresh my memory?

Re: Cannot find slides dealing with EXPLAIN output

From
Robert Treat
Date:
On Wed, 2004-08-11 at 10:30, Alexey Borzov wrote:
> Greetings!
>
> Some time ago I've seen slides from some presentation about PostgreSQL
> performance, those dealt not with the usual postgresql.conf tweaking but with
> making sense out of the EXPLAIN command output.
>

I believe http://www.gtsm.com/oscon2003/toc.html is what you're looking
for.

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


Re: Cannot find slides dealing with EXPLAIN output

From
George Essig
Date:
Alexey Borzov wrote:

> Greetings!
>
> Some time ago I've seen slides from some presentation about PostgreSQL
> performance, those dealt not with the usual postgresql.conf tweaking but with
> making sense out of the EXPLAIN command output.
>
> Unfortunately I misplaced the link and cannot remember either the name of the
> presentation or the names of the people who gave it. Can someone refresh my memory?

How about 'Efficient SQL' by Greg Sabino Mullane at:

http://www.gtsm.com/oscon2003/toc.html

George Essig

Re: Cannot find slides dealing with EXPLAIN output

From
Alexey Borzov
Date:
Hi,

Robert Treat wrote:
>>Some time ago I've seen slides from some presentation about PostgreSQL
>>performance, those dealt not with the usual postgresql.conf tweaking but with
>>making sense out of the EXPLAIN command output.
>
> I believe http://www.gtsm.com/oscon2003/toc.html is what you're looking
> for.

Thanks, that is it!