Re: What about utility to calculate planner cost constants?

From: Thomas F(dot)O'Connell <tfo(at)sitening(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: "Tambet Matiisen" <t(dot)matiisen(at)aprote(dot)ee>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: What about utility to calculate planner cost constants?
Date: 2005-03-21 18:18:17
Message-ID: 11322edfb476c82809712b9796f78a5f@sitening.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

If by not practical you mean, "no one has implemented a multivariable
testing approach," I'll agree with you. But multivariable testing is
definitely a valid statistical approach to solving just such problems.

-tfo

--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005

On Mar 21, 2005, at 11:51 AM, Josh Berkus wrote:

> That's not really practical. There are currently 5 major query tuning
> parameters, not counting the memory adjustments which really can't be
> left
> out. You can't realistically test all combinations of 6 variables.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Hannu Krosing 2005-03-21 18:23:15 Re: What needs to be done for real Partitioning?
Previous Message Josh Berkus 2005-03-21 17:55:03 Re: What needs to be done for real Partitioning?