Home > mailing lists

Would SSD improve Index Only Scan performance by a lot? - Mailing list pgsql-performance

From	Arya F
Subject	Would SSD improve Index Only Scan performance by a lot?
Date	October 9, 2019 02:37:06
Msg-id	CAFoK1axtgKBb-K4ssJ5fiAZgX=abX2Eq-e0m+zXfFifNyg0P5g@mail.gmail.com Whole thread Raw
Responses	Sv: Would SSD improve Index Only Scan performance by a lot? Re: Would SSD improve Index Only Scan performance by a lot? Re: Would SSD improve Index Only Scan performance by a lot?
List	pgsql-performance

As my table has gotten bigger, it takes longer to get a single row back when querying a row by its btree index.

Right now the database is running on a traditional HDD. SSDs have a much faster seek time than traditional HDDs.

Would switching to an SSD improve "Index Only Scan" time greatly? by at least 3-4 times?

From: Ogden Brash
Date: 08 October 2019, 23:20:43
Subject: Modification of data in base folder and very large tables

From: Andreas Joseph Krogh
Date: 09 October 2019, 02:42:26
Subject: Sv: Would SSD improve Index Only Scan performance by a lot?