PostgreSQL settings for running on an SSD drive

Поиск
Список
Период
Сортировка
От CS DBA
Тема PostgreSQL settings for running on an SSD drive
Дата
Msg-id 51C35E6C.1090705@consistentstate.com
обсуждение исходный текст
Ответы Re: PostgreSQL settings for running on an SSD drive
Список pgsql-performance
All;

I'm working with a client running PostgreSQL on a Fusion-IO drive.

They have a PostgreSQL setup guide from Fusion recommending the
following settings:
effective_io_concurrency=0
bgwriter_lru_maxpages=0
random_page_cost=0.1
sequential_page_cost=0.1


These seem odd to me, effectively turning the background writer off,
plus setting both random_page_cost and sequential_page_cost to the same
(very low) value...

Thoughts?


Thanks in advance


В списке pgsql-performance по дате отправления:

Предыдущее
От: Sameer Thakur
Дата:
Сообщение: Re: pg_stat_statements behavior in crash recovery
Следующее
От: Shaun Thomas
Дата:
Сообщение: Re: PostgreSQL settings for running on an SSD drive