pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedSome quick Opteron 32-bit/64-bit results
7+ messages / 4 participants
[nested] [flat]
* Some quick Opteron 32-bit/64-bit results
@ 2004-11-13 22:59 William Yu <wyu@talisys.com>
2004-11-13 23:58 ` Re: Some quick Opteron 32-bit/64-bit results William Yu <wyu@talisys.com>
2004-11-14 00:14 ` Re: Some quick Opteron 32-bit/64-bit results Gustavo Franklin Nóbrega <gfnobrega@planae.com.br>
0 siblings, 2 replies; 7+ messages in thread
From: William Yu @ 2004-11-13 22:59 UTC (permalink / raw)
To: pgsql-performance
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.
Transactional/batch jobs involving client machines (i.e. include fixed
client/networking/odbc overhead) seem to be about 10%-20% faster
although I will need run more data through the system to get a better
feel of the numbers.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Some quick Opteron 32-bit/64-bit results
2004-11-13 22:59 Some quick Opteron 32-bit/64-bit results William Yu <wyu@talisys.com>
@ 2004-11-13 23:58 ` William Yu <wyu@talisys.com>
2004-11-15 07:03 ` Re: Some quick Opteron 32-bit/64-bit results Greg Stark <gsstark@mit.edu>
1 sibling, 1 reply; 7+ messages in thread
From: William Yu @ 2004-11-13 23:58 UTC (permalink / raw)
To: pgsql-performance
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.
William Yu wrote:
> 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.
> Transactional/batch jobs involving client machines (i.e. include fixed
> client/networking/odbc overhead) seem to be about 10%-20% faster
> although I will need run more data through the system to get a better
> feel of the numbers.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Some quick Opteron 32-bit/64-bit results
2004-11-13 22:59 Some quick Opteron 32-bit/64-bit results William Yu <wyu@talisys.com>
2004-11-13 23:58 ` Re: Some quick Opteron 32-bit/64-bit results William Yu <wyu@talisys.com>
@ 2004-11-15 07:03 ` Greg Stark <gsstark@mit.edu>
2004-11-15 07:51 ` Re: Some quick Opteron 32-bit/64-bit results William Yu <wyu@talisys.com>
0 siblings, 1 reply; 7+ messages in thread
From: Greg Stark @ 2004-11-15 07:03 UTC (permalink / raw)
To: William Yu <wyu@talisys.com>; +Cc: pgsql-performance
William Yu <wyu@talisys.com> 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 or 3 times faster in 64-bit mode versus 32-bit.
Isn't this a major kernel bump too? So a different scheduler, different IO
scheduler, etc?
--
greg
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Some quick Opteron 32-bit/64-bit results
2004-11-13 22:59 Some quick Opteron 32-bit/64-bit results William Yu <wyu@talisys.com>
2004-11-13 23:58 ` Re: Some quick Opteron 32-bit/64-bit results William Yu <wyu@talisys.com>
2004-11-15 07:03 ` Re: Some quick Opteron 32-bit/64-bit results Greg Stark <gsstark@mit.edu>
@ 2004-11-15 07:51 ` William Yu <wyu@talisys.com>
2004-11-23 17:20 ` Re: Some quick Opteron 32-bit/64-bit results Cott Lang <cott@internetstaff.com>
0 siblings, 1 reply; 7+ messages in thread
From: William Yu @ 2004-11-15 07:51 UTC (permalink / raw)
To: pgsql-performance
Greg Stark wrote:
> William Yu <wyu@talisys.com> 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 or 3 times faster in 64-bit mode versus 32-bit.
>
>
> Isn't this a major kernel bump too? So a different scheduler, different IO
> scheduler, etc?
>
I'm sure there's some speedup due to the kernel bump. I really didn't
have the patience to even burn the FC2 32-bit CDs much less install both
32-bit & 64-bit FC2 in order to have a more accurate baseline comparison.
However, that being said -- when you see huge speed increases like 50%
100% for dump+gzip, it's doubtful the kernel/process scheduler/IO
scheduler could have made that drastic of a difference. Maybe somebody
else who has done a 2.4 -> 2.6 upgrade can give us a baseline to
subtract from my numbers.
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Some quick Opteron 32-bit/64-bit results
2004-11-13 22:59 Some quick Opteron 32-bit/64-bit results William Yu <wyu@talisys.com>
2004-11-13 23:58 ` Re: Some quick Opteron 32-bit/64-bit results William Yu <wyu@talisys.com>
2004-11-15 07:03 ` Re: Some quick Opteron 32-bit/64-bit results Greg Stark <gsstark@mit.edu>
2004-11-15 07:51 ` Re: Some quick Opteron 32-bit/64-bit results William Yu <wyu@talisys.com>
@ 2004-11-23 17:20 ` Cott Lang <cott@internetstaff.com>
0 siblings, 0 replies; 7+ messages in thread
From: Cott Lang @ 2004-11-23 17:20 UTC (permalink / raw)
To: William Yu <wyu@talisys.com>; +Cc: pgsql-performance
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 <wyu@talisys.com> 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 or 3 times faster in 64-bit mode versus 32-bit.
> >
> >
> > Isn't this a major kernel bump too? So a different scheduler, different IO
> > scheduler, etc?
> >
>
> I'm sure there's some speedup due to the kernel bump. I really didn't
> have the patience to even burn the FC2 32-bit CDs much less install both
> 32-bit & 64-bit FC2 in order to have a more accurate baseline comparison.
>
> However, that being said -- when you see huge speed increases like 50%
> 100% for dump+gzip, it's doubtful the kernel/process scheduler/IO
> scheduler could have made that drastic of a difference. Maybe somebody
> else who has done a 2.4 -> 2.6 upgrade can give us a baseline to
> subtract from my numbers.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Some quick Opteron 32-bit/64-bit results
2004-11-13 22:59 Some quick Opteron 32-bit/64-bit results William Yu <wyu@talisys.com>
@ 2004-11-14 00:14 ` Gustavo Franklin Nóbrega <gfnobrega@planae.com.br>
2004-11-14 00:52 ` Re: Some quick Opteron 32-bit/64-bit results William Yu <wyu@talisys.com>
1 sibling, 1 reply; 7+ messages in thread
From: Gustavo Franklin Nóbrega @ 2004-11-14 00:14 UTC (permalink / raw)
To: William Yu <wyu@talisys.com>; +Cc: pgsql-performance
Hi Willian,
Which are the GCC flags that you it used to compile PostgreSQL?
Best regards,
Gustavo Franklin Nóbrega
Infraestrutura e Banco de Dados
Planae Tecnologia da Informação
(+55) 14 3224-3066 Ramal 209
www.planae.com.br
> 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.
> Transactional/batch jobs involving client machines (i.e. include fixed
> client/networking/odbc overhead) seem to be about 10%-20% faster
> although I will need run more data through the system to get a better
> feel of the numbers.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Some quick Opteron 32-bit/64-bit results
2004-11-13 22:59 Some quick Opteron 32-bit/64-bit results William Yu <wyu@talisys.com>
2004-11-14 00:14 ` Re: Some quick Opteron 32-bit/64-bit results Gustavo Franklin Nóbrega <gfnobrega@planae.com.br>
@ 2004-11-14 00:52 ` William Yu <wyu@talisys.com>
0 siblings, 0 replies; 7+ messages in thread
From: William Yu @ 2004-11-14 00:52 UTC (permalink / raw)
To: pgsql-performance
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 Franklin Nóbrega
> Infraestrutura e Banco de Dados
> Planae Tecnologia da Informação
> (+55) 14 3224-3066 Ramal 209
> www.planae.com.br
>
>
>>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.
>>Transactional/batch jobs involving client machines (i.e. include fixed
>>client/networking/odbc overhead) seem to be about 10%-20% faster
>>although I will need run more data through the system to get a better
>>feel of the numbers.
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 2: you can get off all lists at once with the unregister command
>> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>>
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2004-11-23 17:20 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-13 22:59 Some quick Opteron 32-bit/64-bit results William Yu <wyu@talisys.com>
2004-11-13 23:58 ` William Yu <wyu@talisys.com>
2004-11-15 07:03 ` Greg Stark <gsstark@mit.edu>
2004-11-15 07:51 ` William Yu <wyu@talisys.com>
2004-11-23 17:20 ` Cott Lang <cott@internetstaff.com>
2004-11-14 00:14 ` Gustavo Franklin Nóbrega <gfnobrega@planae.com.br>
2004-11-14 00:52 ` William Yu <wyu@talisys.com>
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