Re: good pc but bad performance,why? - Mailing list pgsql-performance

From Tom Lane
Subject Re: good pc but bad performance,why?
Date
Msg-id 7294.1081390414@sss.pgh.pa.us
Whole thread Raw
In response to Re: good pc but bad performance,why?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: good pc but bad performance,why?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: good pc but bad performance,why?  (Andrew McMillan <andrew@catalyst.net.nz>)
List pgsql-performance
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Tom Lane wrote:
>> But it should be okay to set the filesystem to journal only its own
>> metadata.  There's no need for it to journal file contents.

> Can you set ext2 to journal metadata?  I didn't know it could do that.

No, ext2 has no journal at all AFAIK.  But I believe ext3 has an option
to journal or not journal file contents, and at least on a Postgres-only
volume you'd want to turn that off.

            regards, tom lane

pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: good pc but bad performance,why?
Next
From: Bruce Momjian
Date:
Subject: Re: good pc but bad performance,why?