pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Some 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