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 */
In response to
pgsql-performance by date
|Next:||From: Victor Ciurus||Date: 2004-10-21 17:03:41|
|Subject: Re: Simple machine-killing query!|
|Previous:||From: Tom Lane||Date: 2004-10-21 15:41:48|
|Subject: Re: Simple machine-killing query! |