Postgres Pro
Downloads
Home   >   mailing lists

Re: Cost Model - Mailing list pgsql-hackers

From Neto BR
Subject Re: Cost Model
Date
Msg-id CALhhvc2+i9owbAdz21LX4LD5RNRZjbkNCqu=BeTe0BzdtSQf9Q@mail.gmail.com
Whole thread Raw
In response to Re: Cost Model  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Cost Model  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
List pgsql-hackers
Tree view


2017-12-20 17:32 GMT-02:00 David G. Johnston <david.g.johnston@gmail.com>:
On Wed, Dec 20, 2017 at 12:26 PM, neto brpr <netobrpr@gmail.com> 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 Integer Database and not for Tablespace, ok?. 
You or someone can tell me if cost parameters can be configured by Tablespace, this would be useful for me, thinking of a server that has hybrid storage environment (HDD x SSDs), I could leave some in a tablespace with HDD adapted settings and the same way for when I have an SSD disk.

​ALTER TABLESPACE​



A question about setting random_page_cost and seq_page_cost per tablespace.
If these values ​​are set to tablespace, will the random_page_cost and seq_page_cost parameters of the postgresql.conf file be ignored for the Tablespace that have been configured for these parameters?

Regards, Neto
 
​David J.​



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

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: [HACKERS] Runtime Partition Pruning
Next
From: Jesper Pedersen
Date:
Subject: Re: [HACKERS] Proposal: Local indexes for partitioned table