pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: PFC <lists@peufeu.com>
To: Evgeny Gridasov <eugrid@fpm.kubsu.ru>
Cc: Kevin.Grittner@wicourts.gov
Cc: pgsql-performance@postgresql.org
Subject: Re: Background writer configuration
Date: Fri, 17 Mar 2006 15:55:31 +0100
Message-ID: <op.s6kbqtk6cigqcu@apollo13> (raw)
In-Reply-To: <20060317175017.e15f2151.eugrid@fpm.kubsu.ru>
References: <44181A11.EE98.0025.0@wicourts.gov>
	<20060316211523.73343cee.eugrid@fpm.kubsu.ru>
	<44198B3D.EE98.0025.0@wicourts.gov>
	<20060317152448.452e4854.eugrid@fpm.kubsu.ru>
	<op.s6j701cxcigqcu@apollo13>
	<20060317175017.e15f2151.eugrid@fpm.kubsu.ru>

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 ?
>>
>





view thread (14+ messages)  latest in thread

Message-ID: <op.s6kbqtk6cigqcu@apollo13>
Permalink:  ../op.s6kbqtk6cigqcu@apollo13/
Also on:    postgresql.org/message-id/op.s6kbqtk6cigqcu@apollo13

 · 

reply

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: lists@peufeu.com, eugrid@fpm.kubsu.ru, Kevin.Grittner@wicourts.gov
  Subject: Re: Background writer configuration
  In-Reply-To: <op.s6kbqtk6cigqcu@apollo13>

* 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