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@fpm.kubsu.ru>
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@peufeu.com> 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 ?
>>
>