Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?

Поиск
Список
Период
Сортировка
От Mladen Gogala
Тема Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
Дата
Msg-id 4CE31C31.6090108@vmsinfo.com
обсуждение исходный текст
Ответ на Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?  (Scott Carey <scott@richrelevance.com>)
Список pgsql-performance
Josh Berkus wrote:
> On 11/16/10 12:39 PM, Greg Smith wrote:
>
>> I want to next go through and replicate some of the actual database
>> level tests before giving a full opinion on whether this data proves
>> it's worth changing the wal_sync_method detection.  So far I'm torn
>> between whether that's the right approach, or if we should just increase
>> the default value for wal_buffers to something more reasonable.
>>
>
> We'd love to, but wal_buffers uses sysV shmem.
>
>
Speaking of the SYSV SHMEM, is it possible to use huge pages?

--

Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com
The Leader in Integrated Media Intelligence Solutions




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

Предыдущее
От: Marti Raudsepp
Дата:
Сообщение: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?