Postgres Pro
Downloads
Home   >   mailing lists

Re: Cost Model - Mailing list pgsql-hackers

From neto brpr
Subject Re: Cost Model
Date
Msg-id CALhhvc3XxmjRQ1KrDPj2QgdvH3wGOK18dSLjf1ABpkqez1RxVA@mail.gmail.com
Whole thread Raw
In response to Re: Cost Model  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Cost Model  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Re: Cost Model  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
Tree view
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 

Livre de vírus. www.avast.com.

2017-12-20 15:35 GMT-02:00 David G. Johnston <david.g.johnston@gmail.com>:
On Wed, Dec 20, 2017 at 10:29 AM, neto brpr <netobrpr@gmail.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.


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Letting plpgsql in on the fun with the new expression eval stuff
Next
From: Alvaro Herrera
Date:
Subject: Re: Cost Model