Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1suDSW-0057J4-A7 for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Sep 2024 16:04:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1suDRX-00BTTA-6g for pgsql-hackers@arkaria.postgresql.org; Fri, 27 Sep 2024 16:03:43 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1suDRV-00BTT0-S6 for pgsql-hackers@lists.postgresql.org; Fri, 27 Sep 2024 16:03:42 +0000 Received: from fhigh-a8-smtp.messagingengine.com ([103.168.172.159]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1suDRQ-001Ngn-Sq for pgsql-hackers@postgresql.org; Fri, 27 Sep 2024 16:03:41 +0000 Received: from phl-compute-08.internal (phl-compute-08.phl.internal [10.202.2.48]) by mailfhigh.phl.internal (Postfix) with ESMTP id F2A421140187; Fri, 27 Sep 2024 12:03:35 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-08.internal (MEProxy); Fri, 27 Sep 2024 12:03:35 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ilmari.org; h=cc :cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm1; t=1727453015; x=1727539415; bh=YSJdzrUvdd nIsW8r3cYb0p2M2EeAj0PIIwFtyJkvXDo=; b=VR9dKte5jrHg6pWVJHXpifm5BK nVxNR+mf4hpoQ56+rjG99pBpNPWMYwN370+LVCFWOGXwHFh9uQHUvTLZkwoYBA1U 2Fe1uSfpLhwEKb3u+gJImAIGWmaBnpuZOTt0gWgg9WDocYU85GU3nGuC1MM8A6/X Y29L0K7sB4vxqPMhgkKy/Ae2aO+6hpOlk7NXiyJIsb8SzgI3zkhGSurO3Qdfmauv ig4yV95W/ke4cuAdMgEqn3+bScA4Rx7N8spZErbI40+DBHIOCcjs63DXgSKAxWPl v3IpC2TArTcFDgagc730PUCbPw6ElKqZSlI943TDwyqH5jswHL1ubl/8zYLg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; t=1727453015; x=1727539415; bh=YSJdzrUvddnIsW8r3cYb0p2M2EeA j0PIIwFtyJkvXDo=; b=N/OFGAvzgEAxuDz6pGvAnwSuqRNhSY+4SqEzODzxUop7 yesfmqEHWu8bvO2L1wr+PJiFNLqkOPXZ1mJC4Pnh8QK8rS6IK2BhCguRAVnqG8BQ f8kMYq7/TZRmN5iNJLApYeFouHOqnIp3Xn4GIlAVSXWigpFn5A+eOh8yZRyGlpC2 F5+qQ/wFMJG9x2ZGxqqciUM9fo6CjGs8IJburj7PcPGc8tFL4zsy6rYDJHQ/h6uc KN6wE7YGWjVIIVI4fNfZaDExPti22dwmcGLIaznQHOgO5vjLsjG0kDFLFtbvCU56 FpEJc2ywHQqeWjK63i/ZfkyT0FJZzvOA40vqM4ebFw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrvddtledgleeiucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucenucfjughrpefhvfevuf hfffgjkfgfgggtsehttdertddtreejnecuhfhrohhmpeffrghgfhhinhhnucfklhhmrghr ihcuofgrnhhnshonkhgvrhcuoehilhhmrghrihesihhlmhgrrhhirdhorhhgqeenucggtf frrghtthgvrhhnpeekleejueefhfffkefhkedtfeeluedvieeihfehfeeffeeggeduffdu heejjeeigfenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhroh hmpehilhhmrghrihesihhlmhgrrhhirdhorhhgpdhnsggprhgtphhtthhopedvpdhmohgu vgepshhmthhpohhuthdprhgtphhtthhopehpghhsqhhlqdhhrggtkhgvrhhssehpohhsth hgrhgvshhqlhdrohhrghdprhgtphhtthhopehhthgrmhhfihgushesghhmrghilhdrtgho mh X-ME-Proxy: Feedback-ID: i1ff147bf:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 27 Sep 2024 12:03:35 -0400 (EDT) From: =?utf-8?Q?Dagfinn_Ilmari_Manns=C3=A5ker?= To: Greg Sabino Mullane Cc: pgsql-hackers Subject: Re: Changing the default random_page_cost value References: Date: Fri, 27 Sep 2024 17:03:33 +0100 In-Reply-To: (Greg Sabino Mullane's message of "Fri, 27 Sep 2024 10:07:14 -0400") Message-ID: <877caxaxt6.fsf@wibble.ilmari.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Greg Sabino Mullane 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