Skip site navigation (1) Skip section navigation (2)

Re: Anything to be gained from a 'Postgres Filesystem'?

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Anything to be gained from a 'Postgres Filesystem'?
Date: 2004-10-21 15:49:23
Message-ID: 20041021154923.GA2574@uio.no (view raw or flat)
Thread:
Lists: pgsql-performance
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/

In response to

pgsql-performance by date

Next:From: Victor CiurusDate: 2004-10-21 17:03:41
Subject: Re: Simple machine-killing query!
Previous:From: Tom LaneDate: 2004-10-21 15:41:48
Subject: Re: Simple machine-killing query!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group