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 2DD179DD8B1 for ; Mon, 12 Dec 2005 07:44:03 -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 68611-10 for ; Mon, 12 Dec 2005 07:44:05 -0400 (AST) X-Greylist: delayed 02:47:23.710938 by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by postgresql.org (Postfix) with ESMTP id BB7479DD879 for ; Mon, 12 Dec 2005 07:43:59 -0400 (AST) Received: from galagonx.fixdial.interware.hu (galagonx.fixdial.interware.hu [195.70.45.31]) by svr2.postgresql.org (Postfix) with ESMTP id 1A61CF0B83 for ; Mon, 12 Dec 2005 08:56:36 +0000 (GMT) Received: from szballa-xp.intra ([172.20.80.67]) by galagonx.fixdial.interware.hu with esmtp (Exim 3.36 #1 (Debian)) id 1EljU1-0000QF-00 for ; Mon, 12 Dec 2005 09:56:33 +0100 Message-ID: <439D3AC6.1090405@confinsystems.com> Date: Mon, 12 Dec 2005 09:54:30 +0100 From: Szabolcs BALLA User-Agent: Mozilla Thunderbird 1.0.5 (Windows/20050711) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: 7.4.7 vs. 8.1 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit 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/290 X-Sequence-Number: 16111 Hi, I am ready to install ver. 8.1 to our db server, but I have some questions about it. When I use autovacuum (8.1) is it required to use "vacuum analyze" for maintenance or autovacuum is 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? Is 8.1 stable? Thanks Szabek