On Thu, Oct 21, 2004 at 10:20:55AM -0400, Tom Lane wrote: >> ... I have no idea how much you can improve over the "best" >> filesystems out there, but having two layers of journalling (both WAL _and_ >> FS journalling) on top of each other don't make all that much sense to me. > Which is why setting the FS to journal metadata but not file contents is > often suggested as best practice for a PG-only filesystem.
Mm, but you still journal the metadata. Oh well, noatime etc.. :-) By the way, I'm probably hitting a FAQ here, but would O_DIRECT help PostgreSQL any, given large enough shared_buffers? /* Steinar */ -- Homepage: http://www.sesse.net/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings