Re: Should we update the random_page_cost default value?

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Should we update the random_page_cost default value?
Дата
Msg-id 7d13c50c8d997e3434ecd1924317efa21f2af9ac.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: Should we update the random_page_cost default value?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Should we update the random_page_cost default value?
Список 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 по дате отправления: