Re: Should we update the random_page_cost default value?
David Rowley <dgrowleyml@gmail.com>
From: David Rowley <dgrowleyml@gmail.com>
To: wenhui qiu <qiuwenhuifx@gmail.com>
Cc: Tomas Vondra <tomas@vondra.me>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-10-06T04:46:17Z
Lists: pgsql-hackers
On Mon, 6 Oct 2025 at 17:19, wenhui qiu <qiuwenhuifx@gmail.com> wrote: > I really can't agree more. Many default values are just too conservative, and the documentation doesn't provide best practices.,i think reduce to 1.x,Or add a tip in the document, providing a recommended value for different SSDs. Did you read Tomas's email or just the subject line? I think if you're going to propose to move it in the opposite direction as to what Tomas found to be the more useful direction, then that at least warrants providing some evidence to the contrary of what Tomas has shown or stating that you think his methodology for his calculation is flawed because... I suspect all you've done here is propagate the typical advice people give out around here. It appears to me that Tomas went to great lengths to not do that. David