Re: Tuning PostgreSQL - Mailing list pgsql-performance

From Tom Lane
Subject Re: Tuning PostgreSQL
Date
Msg-id 9304.1059228755@sss.pgh.pa.us
Whole thread Raw
In response to Re: Tuning PostgreSQL  ("Arjen van der Meijden" <acmmailing@vulcanus.its.tudelft.nl>)
List pgsql-performance
"Arjen van der Meijden" <acmmailing@vulcanus.its.tudelft.nl> writes:
> Well, reboting is not a problem with ext2, but crashing might be... And
> normally you don't plan a systemcrash ;)
> Ext3 and xfs handle that much better.

A journaling filesystem is good to use if you can set it to journal
metadata but not file contents.  PG's WAL logic can recover lost file
contents, but we have no way to help out the filesystem if it's lost
metadata.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Arjen van der Meijden"
Date:
Subject: Re: Tuning PostgreSQL
Next
From: "Balazs Wellisch"
Date:
Subject: Re: Tuning PostgreSQL