X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 2E8379DC9BC for ; Fri, 17 Mar 2006 10:55:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 88040-08 for ; Fri, 17 Mar 2006 10:55:21 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from peufeu.com (boutiquenumerique.com [82.67.9.10]) by postgresql.org (Postfix) with ESMTP id E53049DC865 for ; Fri, 17 Mar 2006 10:55:14 -0400 (AST) Received: (qmail 23358 invoked from network); 17 Mar 2006 15:55:31 +0100 Received: from boutiquenumerique.com (HELO apollo13) (82.67.9.10) by boutiquenumerique.com with SMTP; 17 Mar 2006 15:55:31 +0100 To: "Evgeny Gridasov" Cc: Kevin.Grittner@wicourts.gov, pgsql-performance@postgresql.org Subject: Re: Background writer configuration 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> <20060317175017.e15f2151.eugrid@fpm.kubsu.ru> Message-ID: Date: Fri, 17 Mar 2006 15:55:31 +0100 From: PFC Content-Type: text/plain; format=flowed; delsp=yes; charset=utf-8 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit In-Reply-To: <20060317175017.e15f2151.eugrid@fpm.kubsu.ru> User-Agent: Opera M2/8.51 (Linux, build 1462) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.109 required=5 tests=[AWL=0.109] X-Spam-Score: 0.109 X-Spam-Level: X-Archive-Number: 200603/274 X-Sequence-Number: 17711 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 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 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 ? >> >