On Fri, 2004-02-06 at 02:43, Hannu Krosing wrote:
Orion Henry kirjutas N, 05.02.2004 kell 07:16:
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?
Things of note that
On Wed, 2004-02-04 at 21:27, Josh Berkus wrote:
Orion,
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?
No, it's not common knowledge. It should be the other way around.
Orion,
Here's one good example of 7.3 beating 7.4 soundly:
Again this could me some compile option since I built the 7.4 RPM
from source and I got the 7.3 from Fedora or something to
do with the Opteron architecture. (Yes the compiled postgres
is 64 bit)
Need an EXPLAIN ANALYZE, not just
On Thu, 2004-02-05 at 00:32, Christopher Browne wrote:
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
[EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 05, 2004 3:32 AM
Subject: Re: [PERFORM] 7.3 vs 7.4 performance
Oops! [EMAIL PROTECTED] (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
In an attempt to throw the authorities off his trail, [EMAIL PROTECTED] (Carlos
Eduardo Smanioto) transmitted:
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
Josh Berkus [EMAIL PROTECTED] writes:
I'm wondering if we need specific compile-time switches for Opteron. I know
we got Opteron code tweaks in the last version,
Not in 7.4. There is some marginal hacking in the spinlock code in CVS
tip for multi-CPU i386 and x86_64 (viz, add a PAUSE