Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] Very poor read performance, query independent - Mailing list pgsql-performance

From Charles Nadeau
Subject Re: [PERFORM] Very poor read performance, query independent
Date
Msg-id CADFyZw4UanW5TbFajWKWhN9XcW+8gtCXw+kssHo47Wpr1A=zJw@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] Very poor read performance, query independent  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Responses Re: [PERFORM] Very poor read performance, query independent
List pgsql-performance
Tree view
Andreas,

Because the ratio between the Sequential IOPS and Random IOPS is about 29. Taking into account that part of the data is in RAM, I obtained an "effective" ratio of about 22.
Thanks!

Charles

On Mon, Jul 10, 2017 at 5:35 PM, Andreas Kretschmer <andreas@a-kretschmer.de> wrote:


Am 10.07.2017 um 16:03 schrieb Charles Nadeau:
random_page_cost | 22


why such a high value for random_page_cost?

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com



--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



--
Charles Nadeau Ph.D.
http://charlesnadeau.blogspot.com/

pgsql-performance by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: [PERFORM] Very poor read performance, query independent
Next
From: rverghese
Date:
Subject: [PERFORM] vacuum analyze affecting query performance