Horton

Re: Should we update the random_page_cost default value?

Greg Sabino Mullane <htamfids@gmail.com>

View thread
From: Greg Sabino Mullane <htamfids@gmail.com>
To: Robert Treat <rob@xzilla.net>
Cc: Andres Freund <andres@anarazel.de>, Bruce Momjian <bruce@momjian.us>, Tomas Vondra <tomas@vondra.me>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-10-07T19:20:37Z
Lists: 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

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support