From: Jeff Davis <pgsql@j-davis.com>
To: Roman Krylov <rkrylov@mail.ru>
Cc: pgsql-performance@postgresql.org
Subject: Re: 64bit vs 32bit build on amd64
Date: Thu, 07 Sep 2006 09:56:01 -0700
Message-ID: <1157648161.20589.154.camel@dogma.v10.wvs> (raw)
In-Reply-To: <44FC8FB4.4030706@mail.ru>
References: <44FC8FB4.4030706@mail.ru>
On Tue, 2006-09-05 at 00:42 +0400, Roman Krylov wrote:
> Hi.
> My config:
> gentoo linux "2005.1" on amd64x2 in 64-bit mode,
> kernel 2.6.16.12
> glibc 3.3.5(NPTL),
> gcc 3.4.3.
> I had not used portage for building.
> I built two versions of postgres from sources:
> postgresql-8.1.4 native(64bit)
> and 32-bit with CFLAGS=... -m32, and "LD =
> /usr/x86_64-pc-linux-gnu/bin/ld -melf_i386" in src/Makefile.global.
> 32-bit build runs much faster than 64 apparently.
> What benchmark utility should I run to provide more concrete info (numbers)?
> What could be the reason of that difference in performance?
>
I am also interested in 32-bit versus 64-bit performance. If I only have
4GB of RAM, does it make sense to compile postgresql as a 64-bit
executable? I assume there's no reason for PostgreSQL's shared buffers,
etc., to add up to more than 2GB on a system with 4GB of RAM.
Is there a general consensus on the matter, or is it highly application-
dependent? I am not doing any huge amount of 64-bit arithmetic.
I am using Woodcrest, not Opteron.
Regards,
Jeff Davis
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: pgsql@j-davis.com, rkrylov@mail.ru
Subject: Re: 64bit vs 32bit build on amd64
In-Reply-To: <1157648161.20589.154.camel@dogma.v10.wvs>
* 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