Re: Cost Model

Поиск
Список
Период
Сортировка
От Neto BR
Тема Re: Cost Model
Дата
Msg-id CALhhvc2+i9owbAdz21LX4LD5RNRZjbkNCqu=BeTe0BzdtSQf9Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Cost Model  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Cost Model  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
Список pgsql-hackers
Дерево обсуждения


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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: [HACKERS] Runtime Partition Pruning
Следующее
От: Jesper Pedersen
Дата:
Сообщение: Re: [HACKERS] Proposal: Local indexes for partitioned table