From: Christopher Browne <cbbrowne@acm.org>
To: pgsql-performance@postgresql.org
Subject: Re: 64-bit vs 32-bit performance ... backwards?
Date: Tue, 13 Jun 2006 08:23:42 -0400
Message-ID: <87u06pz1kh.fsf@wolfe.cbbrowne.com> (raw)
References: <1150151282.14661.42.camel@tigger>
<54CA6A16-AB42-440D-B5DB-BC43AE283ED8@blighty.com>
<448E11B1.20309@commandprompt.com>
<31554317-AD3E-4D08-92DC-7958E46A0D47@neopolitan.com>
<448E79F4.1060303@superlativ.dk>
Martha Stewart called it a Good Thing when nis@superlativ.dk (Nis Jorgensen) wrote:
> J. Andrew Rogers wrote:
>
>> We have been using PostgreSQL on Opteron servers almost since the
>> Opteron was first released, running both 32-bit and 64-bit versions of
>> Linux. Both 32-bit and 64-bit versions have been bulletproof for us,
>> with the usual stability I've become accustomed to with both PostgreSQL
>> and Linux. We have been running nothing but 64-bit versions on
>> mission-critical systems for the last year with zero problems.
>>
>> The short story is that for us 64-bit PostgreSQL on Opterons is
>> typically something like 20% faster than 32-bit on the same, and *much*
>> faster than P4 Xeon systems they nominally compete with.
>
> Since you sound like you have done extensive testing:
>
> Do you have any data regarding whether to enable hyperthreading or not?
> I realize that this may be highly dependant on the OS, application and
> number of CPUs, but I would be interested in hearing your
> recommendations (or others').
Um, Hyper-Threading? On AMD?
Hyper-Threading is a feature only offered by Intel, on some Pentium 4
chips.
It is not offered by AMD. For our purposes, this is no loss; database
benchmarks have widely shown it to be a performance loser across
various database systems.
--
output = reverse("moc.enworbbc" "@" "enworbbc")
http://linuxdatabases.info/info/languages.html
Yes, for sparkling white chip prints, use low SUDSing DRAW....
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: cbbrowne@acm.org
Subject: Re: 64-bit vs 32-bit performance ... backwards?
In-Reply-To: <87u06pz1kh.fsf@wolfe.cbbrowne.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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