Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B5AB99FA249 for ; Tue, 2 Jan 2007 11:01:07 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 38777-06 for ; Tue, 2 Jan 2007 11:00:57 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from out4.smtp.messagingengine.com (out4.smtp.messagingengine.com [66.111.4.28]) by postgresql.org (Postfix) with ESMTP id 16F8A9FA320 for ; Tue, 2 Jan 2007 11:00:58 -0400 (AST) Received: from out1.internal (unknown [10.202.2.149]) by out1.messagingengine.com (Postfix) with ESMTP id 666A45AFB4 for ; Tue, 2 Jan 2007 09:58:43 -0500 (EST) Received: from web2.messagingengine.com ([10.202.2.211]) by out1.internal (MEProxy); Tue, 02 Jan 2007 09:58:43 -0500 Received: by web2.messagingengine.com (Postfix, from userid 99) id 564064DA2; Tue, 2 Jan 2007 09:58:43 -0500 (EST) Message-Id: <1167749923.22768.282753307@webmail.messagingengine.com> X-Sasl-Enc: u95+IZsoQDm56HDL/z5HlNokz/y875V/B3Drc0txTM4l 1167749923 From: "Jeremy Haile" To: " PostgreSQL Performance" Content-Disposition: inline Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="ISO-8859-1" MIME-Version: 1.0 X-Mailer: MessagingEngine.com Webmail Interface References: <45935A49.6080602@burntmail.com> <20061229220747.GB15429@alvh.no-ip.org> <459A666E.9090508@3times25.net> <1167749696.6369.413.camel@localhost.localdomain> Subject: Re: High update activity, PostgreSQL vs BigDBMS In-Reply-To: Date: Tue, 02 Jan 2007 09:58:43 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/14 X-Sequence-Number: 22615 More specifically, you should set the noatime,data=writeback options in fstab on ext3 partitions for best performance. Correct? > it doesn't really belong here but ext3 has > data journaled (data and meta data) > ordered (meta data journald but data written before meta data (default)) > journald (meta data only journal) > modes. > > The performance differences between ordered and meta data only > journaling should be very small enyway