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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Anything to be gained from a 'Postgres Filesystem'?
Date: 2004-10-21 14:20:55
Message-ID: 15149.1098368455@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Steinar H. Gunderson" <sgunderson(at)bigfoot(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message george young 2004-10-21 14:22:37 Re: create index with substr function
Previous Message Mark Wong 2004-10-21 13:54:58 Re: futex results with dbt-3