From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Cc: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>, tgl(at)sss(dot)pgh(dot)pa(dot)us |
Subject: | Re: A costing analysis tool |
Date: | 2005-10-19 20:03:21 |
Message-ID: | 200510191303.21789.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tino Wildenhain | 2005-10-19 20:04:37 | Re: 'a' == 'a ' (Was: RE: [pgsql-advocacy] Oracle buys |
Previous Message | Dann Corbit | 2005-10-19 19:59:31 | Re: [pgsql-advocacy] Oracle buys Innobase |