pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Carlos Eduardo Smanioto <csmanioto@uol.com.br>
To: Christopher Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: 7.3 vs 7.4 performance
Date: Thu, 5 Feb 2004 09:14:17 -0200
Message-ID: <003c01c3ebd9$35c724e0$cf00a8c0@smanote> (raw)
References: <1075958197.2438.330.camel@orthanc>
	<m3smhqm6qv.fsf@wolfe.cbbrowne.com>

> 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




view thread (16+ messages)  latest in thread

Message-ID: <003c01c3ebd9$35c724e0$cf00a8c0@smanote>
Permalink:  ../003c01c3ebd9$35c724e0$cf00a8c0@smanote/
Also on:    postgresql.org/message-id/003c01c3ebd9$35c724e0$cf00a8c0@smanote

 · 

reply

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: csmanioto@uol.com.br, cbbrowne@acm.org
  Subject: Re: 7.3 vs 7.4 performance
  In-Reply-To: <003c01c3ebd9$35c724e0$cf00a8c0@smanote>

* 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