Re: What about utility to calculate planner cost constants? - Mailing list pgsql-performance

From Tom Lane
Subject Re: What about utility to calculate planner cost constants?
Date
Msg-id 10950.1111517770@sss.pgh.pa.us
Whole thread Raw
In response to Re: What about utility to calculate planner cost constants?  (Greg Stark <gsstark@mit.edu>)
List pgsql-performance
Greg Stark <gsstark@mit.edu> writes:
> Christopher Browne <cbbrowne@acm.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

pgsql-performance by date:

Previous
From: Thomas F.O'Connell
Date:
Subject: Re: [ADMIN] Too slow
Next
From: Alex Turner
Date:
Subject: Re: Planner issue