Re: measuring lwlock-related latency spikes - Mailing list pgsql-hackers

From Robert Haas
Subject Re: measuring lwlock-related latency spikes
Date
Msg-id 4ED52620-A70B-49DF-8B16-C3F753AE2633@gmail.com
Whole thread Raw
In response to Re: measuring lwlock-related latency spikes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Apr 2, 2012, at 3:04 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Seems like basically what you've proven is that this code path *is* a
> performance issue, and that we need to think a bit harder about how to
> avoid doing the fsync while holding locks.

Hmm, good idea. I wonder if we couldn't just hand off the fsync request to the background writer, as we do with buffer
fsyncrequests.  AFAICS we don't need the fsync to happen right away; the next checkpoint cycle should be soon enough. 

...Robert

pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Re: measuring lwlock-related latency spikes
Next
From: Robert Haas
Date:
Subject: Re: measuring lwlock-related latency spikes