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 9AF3B9DCA15 for ; Fri, 17 Mar 2006 10:50: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 90354-01 for ; Fri, 17 Mar 2006 10:50:22 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from office1.i-free.ru (office1.i-free.ru [81.222.216.82]) by postgresql.org (Postfix) with ESMTP id 4F9869DC9BC for ; Fri, 17 Mar 2006 10:50:16 -0400 (AST) Received: from [192.168.0.250] (helo=deepcore.i-free.ru) by office1.i-free.ru with smtp (Exim 3.36 #1 (Debian)) id 1FKGHP-0001rF-00; Fri, 17 Mar 2006 17:50:15 +0300 Date: Fri, 17 Mar 2006 17:50:17 +0300 From: Evgeny Gridasov To: PFC Cc: Kevin.Grittner@wicourts.gov, pgsql-performance@postgresql.org Subject: Re: Background writer configuration Message-Id: <20060317175017.e15f2151.eugrid@fpm.kubsu.ru> In-Reply-To: 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> X-Mailer: Sylpheed version 2.2.3 (GTK+ 2.6.2; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.098 required=5 tests=[AWL=0.098] X-Spam-Score: 0.098 X-Spam-Level: X-Archive-Number: 200603/273 X-Sequence-Number: 17710 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 ? > -- Evgeny Gridasov Software Engineer I-Free, Russia