While Selena and Gabrielle were dining with the other speakers at the
Linux Plumbers Conference, this month's PDXPUG meeting featured Tom
Raney and his Google Summer of Code project at Portland State
University under the mentoring of Dr. Len Shapiro. Before getting
into the details of the Visual Planner, Tom gave a great high level
overview of PostgreSQL's decision making process for determining how
to execute a SQL statement. Then he gave brief description of changes
in the PostgreSQL code that are required in order for the Visual
Planner to capture all the plans that the database considered
executing. Using the tool, Tom demonstrated how to browse through all
the discarded plans to see the cost estimates of each plan indicating
why those plans were discarded. Hopefully people who will be attended
the PostgreSQL West Conference 2008 in October will have a chance to
see Tom repeat his performance.
Len also posed an interesting question that I will try to repeat accurately:
Can anyone come up with an example of a meaningful query where there
is a join that does not use an implicit or explicit foreign key?
There were a couple of new comers and we hope to see them again.
After the meeting some of us headed to the Lucky Lab for refreshments!
pdxpug by date
|Next:||From: Joshua Drake||Date: 2008-09-19 22:02:25|
|Subject: Re: 9/18 Visual Planner Meeting Wrapup|
|Previous:||From: Thomas Keller||Date: 2008-09-18 23:23:03|
|Subject: pgAdmin and pg_hba.conf|