Re: [Testperf-general] Re: ExclusiveLock - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: [Testperf-general] Re: ExclusiveLock
Date
Msg-id 1101156751.2869.147.camel@localhost.localdomain
Whole thread Raw
In response to Re: [Testperf-general] Re: ExclusiveLock  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [Testperf-general] Re: ExclusiveLock
List pgsql-hackers
On Thu, 2004-11-18 at 23:54, Tom Lane wrote:
> I don't think so; WAL is inherently a linear log.  (Awhile ago there was
> some talk of nonlinear log writing to get around the one-commit-per-
> disk-revolution syndrome, but the idea basically got rejected as
> unworkably complicated.)  

...this appears to still be on the TODO list... should it be removed?

- Find a way to reduce rotational delay when repeatedly writing last WAL
page 

Currently fsync of WAL requires the disk platter to perform a full
rotation to fsync again. One idea is to write the WAL to different
offsets that might reduce the rotational delay. 

-- 
Best Regards, Simon Riggs



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 64Bit Solaris Compile
Next
From: Michael Fuhr
Date:
Subject: Re: another plperl bug