Re: [PERFORM] 7.3 vs 7.4 performance

2004-02-06 Thread Orion Henry
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

Re: [PERFORM] 7.3 vs 7.4 performance

2004-02-06 Thread Orion Henry
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.

Re: [PERFORM] 7.3 vs 7.4 performance

2004-02-06 Thread Josh Berkus
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

Re: [PERFORM] 7.3 vs 7.4 performance

2004-02-05 Thread Chris Trawick
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

Re: [PERFORM] 7.3 vs 7.4 performance

2004-02-05 Thread Carlos Eduardo Smanioto
[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

Re: [PERFORM] 7.3 vs 7.4 performance

2004-02-05 Thread Christopher Browne
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

Re: [PERFORM] 7.3 vs 7.4 performance

2004-02-05 Thread Tom Lane
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