Re: Re: [GENERAL] contrib/plantuner - enable PostgreSQL planner hints

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Robert Haas <robertmhaas(at)gmail(dot)com>, Teodor Sigaev <teodor(at)sigaev(dot)ru>, Bruce Momjian <bruce(at)momjian(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Subject: Re: Re: [GENERAL] contrib/plantuner - enable PostgreSQL planner hints
Date: 2009-10-13 18:48:52
Message-ID: 1255459732.11783.62.camel@jd-desktop.unknown.charter.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Tue, 2009-10-13 at 11:26 -0700, Jeff Davis wrote:
> On Tue, 2009-10-13 at 09:14 -0500, Kevin Grittner wrote:
> > Now that we can generate EXPLAIN output in more structured formats,
> > perhaps we could think about adding an "extremely verbose" mode where
> > the planner would "think out loud" as a whole separate section from
> > where we show the chosen plan?
>
> Tom Raney did that a while back:
>
> http://archives.postgresql.org/pgsql-patches/2008-07/msg00011.php
>
> He also had an accompanying visual tool to navigate the output in a
> meaningful way.
>
> If he has moved on to other projects, it would be great if someone could
> pick it up.

No kidding. It was a very cool project. Here is a video of a
presentation he did at West 2008:

http://www.vimeo.com/4101141

Joshua D. Drake

>
> Regards,
> Jeff Davis
>
>
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. - Salamander

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marcelo 2009-10-13 18:49:46 PG 8.4 and pg_autovacuum functionality
Previous Message gmb 2009-10-13 18:27:14 Re: Possible encoding issue (win7)

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2009-10-13 19:46:59 Re: Re: [GENERAL] contrib/plantuner - enable PostgreSQL planner hints
Previous Message Jeff Davis 2009-10-13 18:26:28 Re: Re: [GENERAL] contrib/plantuner - enable PostgreSQL planner hints