X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 15F303A41E0 for ; Wed, 24 Nov 2004 02:24:48 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 74716-07 for ; Wed, 24 Nov 2004 02:24:35 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 560DF3A4202 for ; Wed, 24 Nov 2004 02:24:37 +0000 (GMT) Received: (qmail 27431 invoked by uid 500); 24 Nov 2004 02:36:34 -0000 Date: Tue, 23 Nov 2004 20:36:34 -0600 From: Bruno Wolff III To: Vincent Chen Cc: pgsql-admin@postgresql.org Subject: Re: hardware to get best performance Message-ID: <20041124023634.GA27076@wolff.to> Mail-Followup-To: Vincent Chen , pgsql-admin@postgresql.org References: <20041123143423.32400.qmail@web54409.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20041123143423.32400.qmail@web54409.mail.yahoo.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/178 X-Sequence-Number: 15561 On Tue, Nov 23, 2004 at 22:34:23 +0800, Vincent Chen wrote: > Hi, all > > Does postgresql support thread? Or let me put it this way, will postgresql get > better performance on multiple processor host than single processor? What's the > best platform, freebsd? linux? If you have multiple connections to the database server making simultaneous queries, multiple processors will be used. This is the normal case for real database use. The best platform for you is probably the one you are most familiar with.