Re: [PERFORM] Same SQL, 104296ms of difference between 7.4.12 and 8.0.7

2006-04-07 Thread Tom Lane
I wrote: > Rafael Martinez Guerrero <[EMAIL PROTECTED]> writes: >> I have a sql statement that takes 108489.780 ms with 8.0.7 in a >> RHEL4/amd64linux server with 2xAMD Opteron(tm) Processor 275 2.00GHz / >> 8GB RAM and only 4193.588 ms with 7.4.12 in a RHEL3/386linux server with >> 2xIntel(R) Xeon

Re: [PERFORM] Same SQL, 104296ms of difference between 7.4.12 and 8.0.7

2006-04-07 Thread Tom Lane
Rafael Martinez Guerrero <[EMAIL PROTECTED]> writes: > I have a sql statement that takes 108489.780 ms with 8.0.7 in a > RHEL4/amd64linux server with 2xAMD Opteron(tm) Processor 275 2.00GHz / > 8GB RAM and only 4193.588 ms with 7.4.12 in a RHEL3/386linux server with > 2xIntel(R) Xeon(TM) CPU 2.40GH

[PERFORM] Same SQL, 104296ms of difference between 7.4.12 and 8.0.7

2006-04-07 Thread Rafael Martinez Guerrero
Hello I have a sql statement that takes 108489.780 ms with 8.0.7 in a RHEL4/amd64linux server with 2xAMD Opteron(tm) Processor 275 2.00GHz / 8GB RAM and only 4193.588 ms with 7.4.12 in a RHEL3/386linux server with 2xIntel(R) Xeon(TM) CPU 2.40GHz / 4GB RAM. Some information: - There is no IO when