Re: WAL Optimisation - configuration and usage

Поиск
Список
Период
Сортировка
От Rod Taylor
Тема Re: WAL Optimisation - configuration and usage
Дата
Msg-id 1078015971.24316.9.camel@jester
обсуждение исходный текст
Ответ на WAL Optimisation - configuration and usage  (Rob Fielding <rob@dsvr.net>)
Ответы Re: WAL Optimisation - configuration and usage  (Rob Fielding <rob@dsvr.net>)
Список pgsql-performance
> random_page_cost = 0.5

Not likely. The lowest this value should ever be is 1, and thats if
you're using something like a ram drive.

If you're drives are doing a ton of extra random IO due to the above
(rather than sequential reads) it would lower the throughput quite a
bit.

Try a value of 2 for a while.



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

Предыдущее
От: Mark Gibson
Дата:
Сообщение: Re: [HACKERS] Materialized View Summary
Следующее
От: Rob Fielding
Дата:
Сообщение: Re: WAL Optimisation - configuration and usage