From: | neto brpr <netobrpr(at)gmail(dot)com> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Re: Cost Model |
Date: | 2017-12-20 18:26:00 |
Message-ID: | CALhhvc3XxmjRQ1KrDPj2QgdvH3wGOK18dSLjf1ABpkqez1RxVA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Dear David
I have read documentation that you send, but it has only sequential page
cost and random page cost parameters. What I need, would be a model of
custo for Differentiate Read/Write (sequential and random), because in SSDs
the reads and writes have different costs. If you or someone knows a patch
or other solution, that allows you to configure individual parameters to:
- Sequential reading page cost
- cost of the random reading page
- sequential recording page cost
- Random recording page cost
Best Regards
Neto
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Livre
de vírus. www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>.
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
2017-12-20 15:35 GMT-02:00 David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>:
> On Wed, Dec 20, 2017 at 10:29 AM, neto brpr <netobrpr(at)gmail(dot)com> wrote:
>
>> Any comment, hint about it or something, please inform me.
>>
>
> The docs contain this - its seem to cover what you describe:
>
> https://www.postgresql.org/docs/10/static/runtime-config-
> query.html#RUNTIME-CONFIG-QUERY-CONSTANTS
>
> David J.
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2017-12-20 18:35:23 | Re: Cost Model |
Previous Message | Tom Lane | 2017-12-20 18:13:21 | Re: Letting plpgsql in on the fun with the new expression eval stuff |