From 22fc8d1cfc8ced0722ac0dfe417ce4602a272ebc 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 943cbe656ef..0aa3c97a0ec 100644 --- a/doc/src/sgml/config.sgml +++ b/doc/src/sgml/config.sgml @@ -3360,7 +3360,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