Re: A costing analysis tool

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: josh(at)agliodbs(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: A costing analysis tool
Date: 2005-10-14 15:14:43
Message-ID: 20051014151443.GA28948@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Matt Emmerton 2005-10-14 15:57:07 Re: pg_config --pgxs on Win32
Previous Message Dave Page 2005-10-14 15:13:12 Re: pg_config --pgxs on Win32