X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8EF55475EC9 for ; Wed, 2 Apr 2003 10:13:48 -0500 (EST) Received: from smtp.inode.at (smtp-05.inode.at [62.99.194.7]) by postgresql.org (Postfix) with ESMTP id 2B4A94762A2 for ; Wed, 2 Apr 2003 10:13:17 -0500 (EST) Received: from line-f-208.adsl-dynamic.inode.at ([62.99.193.208]:50006 helo=andi-lap) by smtp.inode.at with smtp (Exim 4.10) id 190juh-0002HL-00; Wed, 02 Apr 2003 17:12:31 +0200 Received: by andi-lap (sSMTP sendmail emulation); Wed, 2 Apr 2003 17:13:19 +0200 Subject: Re: ext3 filesystem / linux 7.3 From: Andreas Kostyrka To: eric soroos Cc: Shankar K , pgsql-performance@postgresql.org, "Jeffrey D.Brower" In-Reply-To: <26287373.1162931668@[4.42.179.151]> References: <26287373.1162931668@[4.42.179.151]> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-iHBxP95beFH/1eZFAO/T" Organization: Message-Id: <1049296398.20242.325.camel@andi-lap> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 Date: 02 Apr 2003 17:13:19 +0200 X-Spam-Status: No, hits=-41.3 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,MAILTO_TO_SPAM_ADDR, PGP_SIGNATURE_2,REFERENCES,REPLY_WITH_QUOTES, USER_AGENT_XIMIAN autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/16 X-Sequence-Number: 1522 --=-iHBxP95beFH/1eZFAO/T Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Tue, 2003-04-01 at 19:53, eric soroos wrote: > On Tue, 1 Apr 2003 09:39:17 -0800 (PST) in message <20030401173917.19476.= qmail@web21101.mail.yahoo.com>, Shankar K wrote: > > hi jeff, > >=20 > > go to > > http://www.ca.postgresql.org/docs/momjian/hw_performance/ > > under 'filesystems' slide. > >=20 >=20 > I suspect that is what he's seen.=20 >=20 > >From my experience, ext3 is only a percent or two slower than ext2 under= pg_bench. It saves an amazing amount of time on startup after a failure by= not having to fsck to confirm that the filesystem is in a consistent state= .=20 >=20 > I believe that ext3 is a metadata journaling system, and not a data journ= aling system. This would indicate that the PG transactioning is complimenta= ry to the filesystem journaling, not duplication.=20 It's both. See the -o data=3Djournal|data=3Dordered|data=3Dwriteback mount time option. Andreas --=-iHBxP95beFH/1eZFAO/T Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQA+iv4LHJdudm4KnO0RArZyAKCO6sa/eRlkzAoNfF+NTzctQcWVCgCgnxL2 S5jjDm1agDbaXwJ5yfvsCAA= =hAhH -----END PGP SIGNATURE----- --=-iHBxP95beFH/1eZFAO/T--