pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feed64bit vs 32bit build on amd64
2+ messages / 2 participants
[nested] [flat]
* 64bit vs 32bit build on amd64
@ 2006-09-04 20:42 Roman Krylov <rkrylov@mail.ru>
2006-09-07 16:56 ` Re: 64bit vs 32bit build on amd64 Jeff Davis <pgsql@j-davis.com>
0 siblings, 1 reply; 2+ messages in thread
From: Roman Krylov @ 2006-09-04 20:42 UTC (permalink / raw)
To: pgsql-performance
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?
Regards,
Roman.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: 64bit vs 32bit build on amd64
2006-09-04 20:42 64bit vs 32bit build on amd64 Roman Krylov <rkrylov@mail.ru>
@ 2006-09-07 16:56 ` Jeff Davis <pgsql@j-davis.com>
0 siblings, 0 replies; 2+ messages in thread
From: Jeff Davis @ 2006-09-07 16:56 UTC (permalink / raw)
To: Roman Krylov <rkrylov@mail.ru>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-09-07 16:56 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-04 20:42 64bit vs 32bit build on amd64 Roman Krylov <rkrylov@mail.ru>
2006-09-07 16:56 ` Jeff Davis <pgsql@j-davis.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