Re: A costing analysis tool

Kevin,

> This would require capture of information beyond what I was thinking
> about in terms of schema.  Do you think we need to capture just index
> type, or something more?  Do you propose that we capture the pg_*
> metadata related to every object referenced in the plan, every object
> related to every table in the query, or everything in the entire
> database?

Not right away.  However, having collected the info in the first place 
would give us the option of duping a copy of the system tables so that we 
could mine them for more information.

Also, for our test harness, we will have pre-programmed object information 
for the objects we use.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco