From: Luke Lonergan <llonergan@greenplum.com>
To: mark@mark.mielke.cc, "Anthony Presley" <anthony@resolution.com>
To: pgsql-performance@postgresql.org
Subject: Re: 64-bit vs 32-bit performance ... backwards?
Date: Mon, 12 Jun 2006 19:57:32 -0700
Message-ID: <C0B377AC.26F41%llonergan@greenplum.com> (raw)
In-Reply-To: <20060613021627.GA4682@mark.mielke.cc>
Mark,
On 6/12/06 7:16 PM, "mark@mark.mielke.cc" <mark@mark.mielke.cc> wrote:
> I haven't. I'm meaning to take a look. Within registers, 64-bit should
> be equal speed to 32-bit. Outside the registers, it would make sense
> to only deal with the lower 32-bits where 32-bits is all that is
> required.
The short answer to all of this as shown in many lab tests by us and
elsewhere (see prior post):
- 64-bit pgsql on Opteron is generally faster than 32-bit, often by a large
amount (20%-30%) on queries that perform sorting, aggregation, etc. It's
generally not slower.
- 64-bit pgsql on Xeon is generally slower than 32-bit by about 5%
So if you have Opterons and you want the best performance, run in 64-bit.
If you have Xeons, you would only run in 64-bit if you use more than 4GB of
memory.
- Luke
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: llonergan@greenplum.com, anthony@resolution.com
Subject: Re: 64-bit vs 32-bit performance ... backwards?
In-Reply-To: <C0B377AC.26F41%llonergan@greenplum.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