On Thu, Feb 9, 2012 at 5:29 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Thu, Feb 9, 2012 at 3:41 PM, Peter van Hardenberg <pvh@xxxxxx> wrote: >> Hmm, perhaps we could usefully aggregate auto_explain output. > > How about something where you run a site at random_page cost of x, > then y, then z and you do some aggregating of query times in each. A > scatter plot should tell you lots. Is there an easy and unintrusive way to get such a metric as the aggregated query times? And to normalize it for how much work happens to have been doing on at the time? Without a good way to do normalization, you could just do lots of tests with randomized settings, to average out any patterns in workload, but that means you need an awful lot of tests to have enough data to rely on randomization. But it would be desirable to do this anyway, in case the normalization isn't as effective as we think. But how long should each setting be tested for? If a different setting causes certain index to start being used, then performance would go down until those indexes get cached and then increase from there. But how long is long enough to allow this to happen? Thanks, Jeff -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
