Re: why SSD is slower than HDD SAS 15K ?

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: why SSD is slower than HDD SAS 15K ?
Date: 2018-01-15 17:13:41
Message-ID: CALd+dcc324VveLc4CX=Om7Yosdn1iH7ud8ytk11VZHhFmbDCHQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Try random page cost 1.1. Way back when I started using SSD we had a
discussion here and came to the conclusion that it should be ever so
slightly higher than sequential page cost.

It is very hard to read your query plans (maybe gmail is wrapping them
funny or you need to use a fixed font on them or share them from
https://explain.depesz.com), but they do look substantially different. My
guess is that with the random page cost = sequential page cost you are
tricking Pg into using more sequential scans than index searches.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neto pr 2018-01-15 17:47:13 Re: why SSD is slower than HDD SAS 15K ?
Previous Message Kellner Thiemo 2018-01-15 15:35:23 RE: pg_basebackup is taking more time than expected