Re: Anything to be gained from a 'Postgres Filesystem'? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Anything to be gained from a 'Postgres Filesystem'?
Date
Msg-id 15149.1098368455@sss.pgh.pa.us
Whole thread Raw
In response to Re: Anything to be gained from a 'Postgres Filesystem'?  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Responses Re: Anything to be gained from a 'Postgres Filesystem'?  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
List pgsql-performance
"Steinar H. Gunderson" <sgunderson@bigfoot.com> writes:
> ... 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.

            regards, tom lane

pgsql-performance by date:

Previous
From: Mark Wong
Date:
Subject: Re: futex results with dbt-3
Next
From: george young
Date:
Subject: Re: create index with substr function