Postgres Pro
Downloads
Home   >   mailing lists

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

From Andreas Joseph Krogh
Subject Sv: Would SSD improve Index Only Scan performance by a lot?
Date
Msg-id VisenaEmail.0.be1ddf58563b9542.16dadbe454a@tc7-visena
Whole thread Raw
In response to Would SSD improve Index Only Scan performance by a lot?  (Arya F <arya6000@gmail.com>)
List pgsql-performance
Tree view
På onsdag 09. oktober 2019 kl. 01:37:06, skrev Arya F <arya6000@gmail.com>:
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?
 
It depends on whether the index is accessed often or not (wrt. caching), and (of course) the size of the index, but yes - "cold access" to the index (or persistent data in general) is much faster with SSD.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment

pgsql-performance by date:

Previous
From: Arya F
Date:
Subject: Would SSD improve Index Only Scan performance by a lot?
Next
From: Rick Otten
Date:
Subject: Re: Would SSD improve Index Only Scan performance by a lot?