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 BFF779DCAC1 for ; Mon, 12 Dec 2005 08:04:59 -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 77528-02 for ; Mon, 12 Dec 2005 08:05:01 -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 001899DD204 for ; Mon, 12 Dec 2005 08:04:55 -0400 (AST) Received: from trofast.ipv6.sesse.net ([2001:700:300:dc03:20e:cff:fe36:a766] helo=trofast.sesse.net) by cassarossa.samfundet.no with esmtp (Exim 4.50) id 1ElmQL-0003za-1H; Mon, 12 Dec 2005 13:04:57 +0100 Received: from sesse by trofast.sesse.net with local (Exim 3.36 #1 (Debian)) id 1ElmQI-0000sj-00; Mon, 12 Dec 2005 13:04:54 +0100 Date: Mon, 12 Dec 2005 13:04:54 +0100 From: "Steinar H. Gunderson" To: pgsql-performance@postgresql.org Cc: Szabolcs BALLA Subject: Re: 7.4.7 vs. 8.1 Message-ID: <20051212120454.GA3356@uio.no> Mail-Followup-To: pgsql-performance@postgresql.org, Szabolcs BALLA References: <439D3AC6.1090405@confinsystems.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <439D3AC6.1090405@confinsystems.com> X-Operating-System: Linux 2.6.14 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/291 X-Sequence-Number: 16112 On Mon, Dec 12, 2005 at 09:54:30AM +0100, Szabolcs BALLA wrote: > When I use autovacuum (8.1) is it required to use "vacuum analyze" for > maintenance or autovacuum is enough? autovacuum should be enough. > We have 2 processors (hyperthread) and is it needed to configure the > psql to use it or is it enough to configure the kernel base only? Turn _off_ hyperthreading; it's more likely to do harm than good. > Is 8.1 stable? Yes. Note that 8.1.1 should be out quite soon. /* Steinar */ -- Homepage: http://www.sesse.net/