Re: [PERFORM] Some quick Opteron 32-bit/64-bit results

2004-11-23 Thread Cott Lang
I ran quite a few file system benchmarks in RHAS x86-64 and FC2 x86-64 on a Sun V40z - I did see very consistent 50% improvements in bonnie++ moving from RHAS to FC2 with ext2/ext3 on SAN. On Sun, 2004-11-14 at 23:51 -0800, William Yu wrote: Greg Stark wrote: William Yu [EMAIL PROTECTED]

Re: [PERFORM] Some quick Opteron 32-bit/64-bit results

2004-11-15 Thread William Yu
Greg Stark wrote: William Yu [EMAIL PROTECTED] writes: Biggest speedup I've found yet is the backup process (PG_DUMP -- GZIP). 100% faster in 64-bit mode. This drastic speed might be more the result of 64-bit GZIP though as I've seen benchmarks in the past showing encryption/compression running 2

[PERFORM] Some quick Opteron 32-bit/64-bit results

2004-11-13 Thread William Yu
I just finished upgrading the OS on our Opteron 148 from Redhat9 to Fedora FC2 X86_64 with full recompiles of Postgres/Apache/Perl/Samba/etc. The verdict: a definite performance improvement. I tested just a few CPU intensive queries and many of them are a good 30%-50% faster.

Re: [PERFORM] Some quick Opteron 32-bit/64-bit results

2004-11-13 Thread William Yu
Biggest speedup I've found yet is the backup process (PG_DUMP -- GZIP). 100% faster in 64-bit mode. This drastic speed might be more the result of 64-bit GZIP though as I've seen benchmarks in the past showing encryption/compression running 2 or 3 times faster in 64-bit mode versus 32-bit.

Re: [PERFORM] Some quick Opteron 32-bit/64-bit results

2004-11-13 Thread William Yu
I gave -O3 a try with -funroll-loops, -fomit-frame-pointer and a few others. Seemed to perform about the same as the default -O2 so I just left it as -O2. Gustavo Franklin Nóbrega wrote: Hi Willian, Which are the GCC flags that you it used to compile PostgreSQL? Best regards, Gustavo