Re: Should we update the random_page_cost default value?

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: Robert Treat <rob(at)xzilla(dot)net>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Bruce Momjian <bruce(at)momjian(dot)us>, Tomas Vondra <tomas(at)vondra(dot)me>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Should we update the random_page_cost default value?
Date: 2025-10-07 19:20:37
Message-ID: CAKAnmmJHe5iHDQwFJf0t6DuBMFJoxotP-njEo=Y8NgCyoGi-hA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Oct 7, 2025 at 3:15 PM Greg Sabino Mullane <htamfids(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Sami Imseih 2025-10-07 19:25:08 Re: Add mode column to pg_stat_progress_vacuum
Previous Message Greg Sabino Mullane 2025-10-07 19:15:02 Re: Should we update the random_page_cost default value?