I got this :
template1=# select version();
version
------------------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 8.1.2 on x86_64-pc-linux-gnu, compiled by GCC
x86_64-pc-linux-gnu-gcc (GCC) 3.4.4 (Gentoo 3.4.4-r1, ssp-3.4.4-1.0,
pie-8.7.8)
(1 ligne)
Normally you should get a noticeable performance boost by using userland
executables compiled for the 64 platform... strange...
On Fri, 17 Mar 2006 15:50:17 +0100, Evgeny Gridasov <eugrid@xxxxxxxxxxxx>
wrote:
template1=# select version();
version
---------------------------------------------------------------------------------------------
PostgreSQL 8.1.3 on x86_64-pc-linux-gnu, compiled by GCC cc (GCC) 3.3.5
(Debian 1:3.3.5-13)
(1 row)
On Fri, 17 Mar 2006 14:35:15 +0100
PFC <lists@xxxxxxxxxx> wrote:
> First of all, I'd like to mention that it was strange to see that
> the server performance degraded by 1-2% when we changed
kernel/userland
> to x86_64
> from default installed i386 userland/amd64 kernel. The operating
system
> was Debian Linux,
> filesystem ext3.
Did you use postgres compiled for AMD64 with the 64 kernel, or did you
use a 32 bit postgres in emulation mode ?
