Re: why SSD is slower than HDD SAS 15K ? - Mailing list pgsql-general

From Vick Khera
Subject Re: why SSD is slower than HDD SAS 15K ?
Date
Msg-id CALd+dcc324VveLc4CX=Om7Yosdn1iH7ud8ytk11VZHhFmbDCHQ@mail.gmail.com
Whole thread Raw
In response to why SSD is slower than HDD SAS 15K ?  (Neto pr <netoprbr9@gmail.com>)
Responses Re: why SSD is slower than HDD SAS 15K ?  (Neto pr <netoprbr9@gmail.com>)
List 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.

pgsql-general by date:

Previous
From: Kellner Thiemo
Date:
Subject: RE: pg_basebackup is taking more time than expected
Next
From: Neto pr
Date:
Subject: Re: why SSD is slower than HDD SAS 15K ?