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 <andr...@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/
