Re: no universally correct setting for fsync

Поиск
Список
Период
Сортировка
От Michael Tharp
Тема Re: no universally correct setting for fsync
Дата
Msg-id 4BE81CA1.4080201@partiallystapled.com
обсуждение исходный текст
Ответ на Re: no universally correct setting for fsync  (Craig Ringer <craig@postnewspapers.com.au>)
Ответы Re: no universally correct setting for fsync  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
On 05/08/2010 04:07 AM, Craig Ringer wrote:
> It's probably worth mentioning that people who want to turn off fsync to
> gain a performance boost should instead look at a RAID controller with a
> BBU so they can safely enable write-back caching, getting most of the
> benefits of fsync=off safely.

Which options specifically should be set if a BBU is in use? Obviously 
fsync should be on always, but can full_page_writes be disabled? Are 
there other tweaks that can be done?

It would be great to see some practical hints in the documentation while 
the fsync part is getting changed.

-- m. tharp


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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: max_standby_delay considered harmful
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: max_standby_delay considered harmful