Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? - Mailing list pgsql-performance

From Mladen Gogala
Subject Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
Date
Msg-id 4CE31C31.6090108@vmsinfo.com
Whole thread Raw
In response to Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?  (Scott Carey <scott@richrelevance.com>)
List 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 by date:

Previous
From: Marti Raudsepp
Date:
Subject: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
Next
From: Andres Freund
Date:
Subject: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?