X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id AD5D0D1D916 for ; Mon, 1 Dec 2003 22:24:54 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 03195-04 for ; Mon, 1 Dec 2003 18:24:25 -0400 (AST) Received: from jhuml1.jhmi.edu (jhuml1.jhmi.edu [162.129.234.20]) by svr1.postgresql.org (Postfix) with ESMTP id 0D31AD1D383 for ; Mon, 1 Dec 2003 18:24:22 -0400 (AST) Received: from jhuml1.jhmi.edu (jhuml1.jhmi.edu [162.129.234.20]) by jhuml1.jhmi.edu (PMDF V6.2-X17 #30839) with SMTP id <0HP800CBLM7D7X@jhuml1.jhmi.edu> for pgsql-performance@postgresql.org; Mon, 01 Dec 2003 17:24:23 -0500 (EST) Received: from jhuml1.jhmi.edu ([162.129.234.20]) by jhuml1.jhmi.edu (SAVSMTP 3.1.0.29) with SMTP id M2003120117242205892 for ; Mon, 01 Dec 2003 17:24:22 -0500 Received: from jhmimail.jhmi.edu (jhem2.jhmi.edu [162.129.8.23]) by jhuml1.jhmi.edu (PMDF V6.2-X17 #30839) with ESMTP id <0HP800CQRM8M7X@jhuml1.jhmi.edu> for pgsql-performance@postgresql.org; Mon, 01 Dec 2003 17:24:22 -0500 (EST) Received: from [162.129.178.60] by jhmimail.jhmi.edu (mshttpd); Mon, 01 Dec 2003 22:27:51 +0000 (GMT) Date: Mon, 01 Dec 2003 22:27:51 +0000 (GMT) From: LIANHE SHAO Subject: Is clustering possible to enhance the performance? To: pgsql-performance Message-id: <6b5ba36baf6d.6baf6d6b5ba3@jhmimail.jhmi.edu> MIME-version: 1.0 X-Mailer: iPlanet Messenger Express 5.2 HotFix 1.17 (built Jun 23 2003) Content-type: text/plain; charset=us-ascii Content-language: en Content-transfer-encoding: 7bit Content-disposition: inline X-Accept-Language: en X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/19 X-Sequence-Number: 4879 Hello, I am wondering if it is possible to use several machine as cluster to boost the slow queries. Is that possible? Anybody have tried that before? Initially, I was thinking to use dual CPUS instead of one. but it is not correct because pgsql is not multi-threaded. Any suggestions are welcome and appreciated, Regards, William