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 70B583A42A1 for ; Wed, 24 Nov 2004 05:30:38 +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 10069-01 for ; Wed, 24 Nov 2004 05:30:34 +0000 (GMT) Received: from web54401.mail.yahoo.com (web54401.mail.yahoo.com [68.142.225.157]) by svr1.postgresql.org (Postfix) with SMTP id C22643A42B5 for ; Wed, 24 Nov 2004 05:30:17 +0000 (GMT) Received: (qmail 79882 invoked by uid 60001); 24 Nov 2004 05:30:06 -0000 Message-ID: <20041124053006.79880.qmail@web54401.mail.yahoo.com> Received: from [61.221.104.182] by web54401.mail.yahoo.com via HTTP; Wed, 24 Nov 2004 13:30:06 CST Date: Wed, 24 Nov 2004 13:30:06 +0800 (CST) From: Vincent Chen Subject: Re: hardware to get best performance To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=big5 Content-Transfer-Encoding: 8bit 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/187 X-Sequence-Number: 15570 >> 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. > About platform, linux has much more filesystem choice than freebsd. If I put postgresql data file on new filesystem like xfs or reiserfs, is it possible that overall performance will be better than old filesystem like ufs? Thanks for your response, Vincent Chen ----------------------------------------------------------------- Yahoo!奇摩造型精靈 最新的造型精靈簽名檔,讓信件獨具個人色彩! http://tw.avatar.yahoo.com/