Re: Cost Model

Поиск
Список
Период
Сортировка
От neto brpr
Тема Re: Cost Model
Дата
Msg-id CALhhvc3XxmjRQ1KrDPj2QgdvH3wGOK18dSLjf1ABpkqez1RxVA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Cost Model  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Cost Model  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Re: Cost Model  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список 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 

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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Letting plpgsql in on the fun with the new expression eval stuff
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Cost Model