Re: Should we update the random_page_cost default value? - Mailing list pgsql-hackers

From Laurenz Albe
Subject Re: Should we update the random_page_cost default value?
Date
Msg-id 7d13c50c8d997e3434ecd1924317efa21f2af9ac.camel@cybertec.at
Whole thread Raw
In response to Re: Should we update the random_page_cost default value?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Should we update the random_page_cost default value?
List pgsql-hackers
On Mon, 2025-10-06 at 01:29 -0400, Tom Lane wrote:
> But if what
> we're trying to model is net resource demands, with an eye to
> minimizing the total system load not execution time of any one query,
> maybe we can continue to work with something close to what we've
> traditionally done.

Did anybody propose that?
I was under the impression that PostgreSQL's cost model tries to
estimate and optimize execution time, not resource consumption.
Changing that would be pretty radical.  For example, it would be
quite obvious that we'd have to disable parallel query by default.

But perhaps I misunderstood, or perhaps I am just too conservative.

Yours,
Laurenz Albe



pgsql-hackers by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Should we update the random_page_cost default value?
Next
From: Tom Lane
Date:
Subject: Re: Should we update the random_page_cost default value?