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@xxxxxxxxxxxxxxx> 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/
http://charlesnadeau.blogspot.com/
