Re: what's the slowest part in the SQL - Mailing list pgsql-performance

From Tom Lane
Subject Re: what's the slowest part in the SQL
Date
Msg-id 12338.1470789923@sss.pgh.pa.us
Whole thread Raw
In response to Re: what's the slowest part in the SQL  (Suya Huang <shuang@connexity.com>)
Responses Re: what's the slowest part in the SQL  (Suya Huang <shuang@connexity.com>)
List pgsql-performance
Suya Huang <shuang@connexity.com> writes:
>                ->  Index Scan using idx_order_1_us on order o  (cost=0.56..8.58 rows=1 width=30) (actual
time=5.814..5.814rows=0 loops=526) 

4 or so ms per row fetched is well within expectation for random access to
spinning-rust media.  For example, a 15K RPM drive spins at 4 ms per
revolution, so rotational delay alone would probably explain this number,
never mind needing to do any seeks.  So I see nothing even slightly
unexpected here, assuming that the "order" table is large enough that none
of what you need is in RAM already.  If you need more performance, look
into SSDs.

(If you have storage kit for which you'd expect better performance than
this, you should start by explaining what it is.)

            regards, tom lane


pgsql-performance by date:

Previous
From: Suya Huang
Date:
Subject: Re: what's the slowest part in the SQL
Next
From: Claudio Freire
Date:
Subject: Re: what's the slowest part in the SQL