X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 15F8FD1CCCC for ; Fri, 6 Feb 2004 17:06:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 88300-02 for ; Fri, 6 Feb 2004 13:06:47 -0400 (AST) Received: from mail.osdl.org (fw.osdl.org [65.172.181.6]) by svr1.postgresql.org (Postfix) with ESMTP id 3B275D1CAF6 for ; Fri, 6 Feb 2004 13:06:44 -0400 (AST) Received: from osdl.org (markw@ibm-b.pdx.osdl.net [172.20.1.51]) by mail.osdl.org (8.11.6/8.11.6) with ESMTP id i16H5LN16010; Fri, 6 Feb 2004 09:05:22 -0800 Message-Id: <200402061705.i16H5LN16010@mail.osdl.org> Date: Fri, 6 Feb 2004 09:05:04 -0800 (PST) From: markw@osdl.org Subject: Re: 7.3 vs 7.4 performance To: csmanioto@uol.com.br Cc: cbbrowne@acm.org, pgsql-performance@postgresql.org In-Reply-To: <003c01c3ebd9$35c724e0$cf00a8c0@smanote> MIME-Version: 1.0 Content-Type: TEXT/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/96 X-Sequence-Number: 5620 I have some results with our DBT-2 (OLTP) workload on various linux-2.6 filesystems, if you'll find that interesting: http://developer.osdl.org/markw/fs/dbt2_project_results.html I've found JFS to perform similarly to ext2. Reiserfs isn't far behind. XFS and ext3 fall off a bit. These results are also on a 4-way Xeon, with about 70 drives and a ~ 30GB database. Mark On 5 Feb, Carlos Eduardo Smanioto wrote: >> I did some heavy-transaction-oriented tests recently on somewhat >> heftier quad-Xeon hardware, and found little difference between 2.4 >> and 2.6, and a small-but-quite-repeatable advantage with FreeBSD 4.9. >> Now, I'm quite sure my load was rather different from yours, but I >> find the claim of doubling of speed rather surprising. >> -- > > What's the type of File System you used in the Linux? I am wanting to know > which is the operational system better for PostgreSQL: FreeBSD versus Linux > 2.6. > > Thanks. > > []'s > Carlos Eduardo Smanioto (Brazil) > > ----- Original Message ----- > From: "Christopher Browne" > To: > Sent: Thursday, February 05, 2004 3:32 AM > Subject: Re: [PERFORM] 7.3 vs 7.4 performance > > >> Oops! orion@trustcommerce.com (Orion Henry) was seen spray-painting on a > wall: >> > I've done some testing of 7.3.4 vs 7.4.1 and found 7.4.1 to be 20%-30% >> > slower than 7.3.4. Is this common knowledge or am I just unlucky with >> > my query/data selection? >> >> That seems unusual; the opposite seems more typical in view of there >> being some substantial improvements to the query optimizer. >> >> Have you tried doing EXPLAIN ANALYZE on the queries on both sides? >> There would doubtless be interest in figuring out what is breaking >> down... >> >> > Things of note that might matter: the machine is a dual Opteron >> > 1.4GHz running Fedora Core 1 Test 1 for X86_64. The 7.3.4 was from >> > the Fedora distro and the 7.4.1 was the PGDG package. The database >> > is 3.5 Gigs with 10 millions rows and the machine had 1 Gig or ram. >> > >> > Oh... as a side note I'm happy to announce that the 2.6 Linux kernel >> > has more than DOUBLED the speed of all my Postgres queries over the >> > 2.4. =) >> >> I did some heavy-transaction-oriented tests recently on somewhat >> heftier quad-Xeon hardware, and found little difference between 2.4 >> and 2.6, and a small-but-quite-repeatable advantage with FreeBSD 4.9. >> Now, I'm quite sure my load was rather different from yours, but I >> find the claim of doubling of speed rather surprising. >> -- >> (format nil "~S@~S" "aa454" "freenet.carleton.ca") >> http://www.ntlug.org/~cbbrowne/spiritual.html >> Failure is not an option. It comes bundled with your Microsoft product. >> >> ---------------------------(end of broadcast)--------------------------- >> TIP 5: Have you checked our extensive FAQ? >> >> http://www.postgresql.org/docs/faqs/FAQ.html > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly