From: | yamt(at)mwd(dot)biglobe(dot)ne(dot)jp (YAMAMOTO Takashi) |
---|---|
To: | robertmhaas(at)gmail(dot)com |
Cc: | simon(at)2ndquadrant(dot)com, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: synchronous commit vs. hint bits |
Date: | 2011-11-30 06:37:29 |
Message-ID: | 20111130063729.C15EE14A223@mail.netbsd.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
hi,
> On Tue, Nov 29, 2011 at 1:42 AM, YAMAMOTO Takashi
> <yamt(at)mwd(dot)biglobe(dot)ne(dot)jp> wrote:
>>> On Mon, Nov 7, 2011 at 5:26 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
>>>
>>>>> 5. Make the WAL writer more responsive, maybe using latches, so that
>>>>> it doesn't take as long for the commit record to make it out to disk.
>>>>
>>>> I'm working on this already as part of the update for power
>>>> reduction/group commit/replication performance.
>>>
>>> I extracted this from my current patch for you to test.
>>
>> is it expected to produce more frequent fsync?
>
> Yes, I would expect that. What kind of increase are you seeing? Is
> it causing a problem for you, or are you just making an observation?
i was curious because my application uses async commits mainly to
avoid frequent fsync. i have no numbers right now.
YAMAMOTO Takashi
>
> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2011-11-30 08:02:51 | Re: Word-smithing doc changes |
Previous Message | Tom Lane | 2011-11-30 06:05:14 | Re: Patch - Debug builds without optimization |