On Thu, Dec 21, 2017 at 3:09 PM, Neto BR wrote:
>
>
> 2017-12-20 17:32 GMT-02:00 David G. Johnston :
>
>> On Wed, Dec 20, 2017 at 12:26 PM, neto brpr wrote:
>>
>>>
>>> About what you said, that some settings can be configured by Tablespace?
>>> I have already seen this in IBM DB2, but in Postgre
2017-12-20 17:32 GMT-02:00 David G. Johnston :
> On Wed, Dec 20, 2017 at 12:26 PM, neto brpr wrote:
>
>>
>> About what you said, that some settings can be configured by Tablespace?
>> I have already seen this in IBM DB2, but in Postgresql as far as I know,
>> for example the Random_page_cost and
2017-12-20 17:34 GMT-02:00 Andres Freund :
> On 2017-12-20 17:13:31 -0200, neto brpr wrote:
> > Just to explain it better. The idea of differentiating read and write
> > parameters (sequential and random) is exactly so that the access plans
> can
> > be better chosen by the optimizer. But for th
On 2017-12-20 17:13:31 -0200, neto brpr wrote:
> Just to explain it better. The idea of differentiating read and write
> parameters (sequential and random) is exactly so that the access plans can
> be better chosen by the optimizer. But for this, the Hash join, merge join,
> sorting and other alg
On Wed, Dec 20, 2017 at 12:26 PM, neto brpr wrote:
>
> About what you said, that some settings can be configured by Tablespace?
> I have already seen this in IBM DB2, but in Postgresql as far as I know,
> for example the Random_page_cost and Seq_page_cost parameters are
> configured for the Integ
2017-12-20 16:37 GMT-02:00 David G. Johnston :
> On Wed, Dec 20, 2017 at 11:26 AM, neto brpr wrote:
>
>> 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
neto brpr wrote:
> Anyway, It seems that there has not yet been any initiative related to this
> in the postgresql community, am I right?
Yes.
--
Álvaro Herrerahttps://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
2017-12-20 16:35 GMT-02:00 Alvaro Herrera :
> neto brpr wrote:
> > 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), beca
On Wed, Dec 20, 2017 at 11:26 AM, neto brpr wrote:
> 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 r
neto brpr wrote:
> 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
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
On Wed, Dec 20, 2017 at 10:29 AM, neto brpr 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.
12 matches
Mail list logo
