Re: Changing the default random_page_cost value

From: Dagfinn Ilmari Mannsåker <ilmari(at)ilmari(dot)org>
To: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Changing the default random_page_cost value
Date: 2024-09-27 16:03:33
Message-ID: 877caxaxt6.fsf@wibble.ilmari.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greg Sabino Mullane <htamfids(at)gmail(dot)com> writes:

> So I'll be brave and throw a number out there: 1.2. And change our
> docs to say wordage like "if you are using an older hard disk drive
> technology, you may want to try raising rpc" to replace our
> fairly-hidden note about SSDs buried in the last sentence - of the
> fourth paragraph - of the rpc docs.

It might also be worth mentioning cloudy block storage (e.g. AWS' EBS),
which is typically backed by SSDs, but has extra network latency.

- ilmari

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2024-09-27 16:22:48 Re: MAINTAIN privilege -- what do we need to un-revert it?
Previous Message Nathan Bossart 2024-09-27 15:44:00 Re: micro-optimize nbtcompare.c routines