Horton

Re: good pc but bad performance,why?

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: "scott.marlowe" <scott.marlowe@ihs.com>, Andrew McMillan <andrew@catalyst.net.nz>, huang yaqin <hyq@gthome.com>, pgsql-performance@postgresql.org
Date: 2004-04-08T02:13:34Z
Lists: 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