Would SSD improve Index Only Scan performance by a lot?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux