From: markw@osdl.org
To: csmanioto@uol.com.br
Cc: cbbrowne@acm.org
Cc: pgsql-performance@postgresql.org
Subject: Re: 7.3 vs 7.4 performance
Date: Fri, 6 Feb 2004 09:05:04 -0800 (PST)
Message-ID: <200402061705.i16H5LN16010@mail.osdl.org> (raw)
In-Reply-To: <003c01c3ebd9$35c724e0$cf00a8c0@smanote>
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" <cbbrowne@acm.org>
> To: <pgsql-performance@postgresql.org>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: markw@osdl.org, csmanioto@uol.com.br, cbbrowne@acm.org
Subject: Re: 7.3 vs 7.4 performance
In-Reply-To: <200402061705.i16H5LN16010@mail.osdl.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox