Re: A costing analysis tool - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: A costing analysis tool
Date
Msg-id 20051014151443.GA28948@svana.org
Whole thread Raw
In response to Re: A costing analysis tool  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: A costing analysis tool
List pgsql-hackers
On Thu, Oct 13, 2005 at 05:39:32PM -0500, Kevin Grittner wrote:
> That said, there's certainly overlap between your effort and
> what I'm going to be developing.  Do you have anything from
> your work which might save me some time?

Not really. I got stuck in the query design phase. I didn't even
generate any tables :(

> There's a chance that I may be able to talk my client into
> putting a web app guy on this for a few days to make it pretty.

You misunderstand. I don't think a pretty website is seriously needed.
Just a consistant output format with the results in a tarball complete
with information about the system itself that people can upload. Then
anyone can download a few and combine them as they want. Just an ftp
server, maybe gforge or whatever.

As for the use of cost estimates, I think it's the same problem from
different angles. Comparing the estimates with actual time is
determining where the current system is wrong. Comparing actual times
with eachother might tell you what the model should be. As has been
pointed out, the raw data is what's needed. From there you can draw
conclusions.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

pgsql-hackers by date:

Previous
From: "Dave Page"
Date:
Subject: Re: pg_config --pgxs on Win32
Next
From: "Andrew Dunstan"
Date:
Subject: Re: Request for a 'force interactive mode' flag (-I) for