Would SSD improve Index Only Scan performance by a lot?

From: Arya F <arya6000(at)gmail(dot)com>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Would SSD improve Index Only Scan performance by a lot?
Date: 2019-10-08 23:37:06
Message-ID: CAFoK1axtgKBb-K4ssJ5fiAZgX=abX2Eq-e0m+zXfFifNyg0P5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andreas Joseph Krogh 2019-10-08 23:42:26 Sv: Would SSD improve Index Only Scan performance by a lot?
Previous Message Ogden Brash 2019-10-08 20:20:43 Modification of data in base folder and very large tables