From 7bf6b3e0075538598a1fb02a11f3080678814ed5 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 21 May 2020 20:28:38 -0400 Subject: [PATCH] doc: suggest 1.1 as a random_page_cost value for SSDs Reported-by: yigong hu Discussion: https://postgr.es/m/CAOxFffcourucFqSk+tZA13ErS3XRYkDy6EeaPff4AvHGiEEuug@mail.gmail.com Backpatch-through: 9.5 --- doc/src/sgml/config.sgml | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/config.sgml b/doc/src/sgml/config.sgml index 92681cf4530..d56f4274070 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -3650,7 +3650,8 @@ include_dir 'conf.d' the database is smaller than the total server memory, decreasing random_page_cost can be appropriate. Storage that has a low random read cost relative to sequential, e.g. solid-state drives, might - also be better modeled with a lower value for random_page_cost. + also be better modeled with a lower value for random_page_cost, + e.g., 1.1. -- 2.39.5