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 AB4B89DCC7F for ; Sat, 17 Dec 2005 22:18:42 -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 79674-02 for ; Sat, 17 Dec 2005 22:18:45 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from cassarossa.samfundet.no (cassarossa.samfundet.no [129.241.93.19]) by postgresql.org (Postfix) with ESMTP id 0CA799DCD75 for ; Sat, 17 Dec 2005 22:18:38 -0400 (AST) Received: from trofast.sesse.net ([129.241.93.32]) by cassarossa.samfundet.no with esmtp (Exim 4.50) id 1Eno8H-0000gf-MY for pgsql-performance@postgresql.org; Sun, 18 Dec 2005 03:18:41 +0100 Received: from sesse by trofast.sesse.net with local (Exim 3.36 #1 (Debian)) id 1Eno8G-0004Fa-00 for ; Sun, 18 Dec 2005 03:18:40 +0100 Date: Sun, 18 Dec 2005 03:18:40 +0100 From: "Steinar H. Gunderson" To: pgsql-performance@postgresql.org Subject: Re: PostgreSQL performance question. [OT] Message-ID: <20051218021840.GA16308@uio.no> Mail-Followup-To: pgsql-performance@postgresql.org References: <45b42ce40512141751i6829eec0q6d088b1ec5bc27b4@mail.gmail.com> <43A0CEAA.6060800@familyhealth.com.au> <45b42ce40512171811r293e254ex94a4e69910f80466@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <45b42ce40512171811r293e254ex94a4e69910f80466@mail.gmail.com> X-Operating-System: Linux 2.6.14.3 on a x86_64 X-Message-Flag: Outlook? --> http://www.mozilla.org/products/thunderbird/ User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/434 X-Sequence-Number: 16255 On Sun, Dec 18, 2005 at 02:11:16AM +0000, Harry Jackson wrote: > The one thing that may be skewing these results is that this was > compiled and installed from source with > > ./configure CFLAGS='-O2' --with-openssl --enable-thread-safety > > I am not sure what the default Debian binary for 7.4.7 is compiled > with so this may have had some affect. This isn't a performance note, but you might be interested in hearing that there are being maintained official backports of 8.0 and 8.1 for Debian sarge (by Martin Pitt, the same person who maintains both the sarge and sid versions). Take a look at http://people.debian.org/~mpitt/packages/sarge-backports/ It might be more comfortable in the long run than maintaining your own source installation, although YMMV. /* Steinar */ -- Homepage: http://www.sesse.net/