Обсуждение: Cannot find slides dealing with EXPLAIN output

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?

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

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

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!