Re: What about utility to calculate planner cost constants?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Christopher Browne <cbbrowne(at)acm(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: What about utility to calculate planner cost constants?
Date: 2005-03-22 18:56:10
Message-ID: 10950.1111517770@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Greg Stark <gsstark(at)mit(dot)edu> writes:
> Christopher Browne <cbbrowne(at)acm(dot)org> writes:
>> Are you certain it's a linear system?

> If you just consider the guc parameters that tell postgres how long various
> real world operations take (all the *_cost parameters) then it's a linear
> system. It has to be.

No it doesn't. Think caching effects for instance. We do have cache
effects in the cost models, even though they are wrong as per my nearby
rant...

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2005-03-22 18:57:35 Re: CPU 0.1% IOWAIT 99% for decisonnal queries
Previous Message Thomas F.O'Connell 2005-03-22 18:50:29 Re: [ADMIN] Too slow