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

From Greg Sabino Mullane
Subject Re: Should we update the random_page_cost default value?
Date
Msg-id CAKAnmmJHe5iHDQwFJf0t6DuBMFJoxotP-njEo=Y8NgCyoGi-hA@mail.gmail.com
Whole thread Raw
In response to Re: Should we update the random_page_cost default value?  (Greg Sabino Mullane <htamfids@gmail.com>)
Responses Re: Should we update the random_page_cost default value?
List pgsql-hackers
On Tue, Oct 7, 2025 at 3:15 PM Greg Sabino Mullane <htamfids@gmail.com> wrote:
One of the take-away lessons from this thread for me is that the TPC-* benchmarks are far removed from real world queries. (Maybe if we ask an LLM to use an ORM to implement TPC-H? Ha ha ha!)

To be clear, I'm saying that TPC queries are written by sane adults that know what they are doing, but perhaps lowering rpc tends to help more when the queries are not well-written SQL (which many consultants would argue is the majority of production queries).

 
Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-hackers by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: Should we update the random_page_cost default value?
Next
From: Sami Imseih
Date:
Subject: Re: Add mode column to pg_stat_progress_vacuum