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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html