| From: | Charles Nadeau <charles(dot)nadeau(at)gmail(dot)com> |
|---|---|
| To: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Very poor read performance, query independent |
| Date: | 2017-07-10 15:48:25 |
| Message-ID: | CADFyZw4UanW5TbFajWKWhN9XcW+8gtCXw+kssHo47Wpr1A=zJw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(at)a-kretschmer(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
--
Charles Nadeau Ph.D.
http://charlesnadeau.blogspot.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | rverghese | 2017-07-10 17:25:07 | vacuum analyze affecting query performance |
| Previous Message | Andreas Kretschmer | 2017-07-10 15:35:56 | Re: Very poor read performance, query independent |