X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B964C3AB184 for ; Tue, 21 Dec 2004 11:16:53 +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 43000-03 for ; Tue, 21 Dec 2004 11:16:47 +0000 (GMT) Received: from anchor-post-35.mail.demon.net (anchor-post-35.mail.demon.net [194.217.242.85]) by svr1.postgresql.org (Postfix) with ESMTP id 663DB3A9E50 for ; Tue, 21 Dec 2004 11:16:48 +0000 (GMT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-35.mail.demon.net with esmtp (Exim 4.42) id 1Cghzi-000Hiu-I2; Tue, 21 Dec 2004 11:15:58 +0000 Received: from [192.168.1.17] (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 8B95E164FD; Tue, 21 Dec 2004 11:16:44 +0000 (GMT) Message-ID: <41C8061C.10700@archonet.com> Date: Tue, 21 Dec 2004 11:16:44 +0000 From: Richard Huxton User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Kenneth Gonsalves Cc: pgsql-sql@postgresql.org Subject: Re: linux clusters and pgsql References: <0412211529020J.02019@thenilgiris.com> In-Reply-To: <0412211529020J.02019@thenilgiris.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.082 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200412/146 X-Sequence-Number: 19766 Kenneth Gonsalves wrote: > hi, can postgres be run on a linux cluster, and if so what are the > performance and other issues - checked archives, but the only info is > over a year old PG uses shared memory to communicate between backends. Even if your clustering technology can handle that, it's unlikely to be useful without exotic hardware. The main problem is bandwidth between the backends - they're not terribly independent, so you need a specialised backplane usually. I think there is someone producing exotic hardware with a version called "clusgres" or similar. Not sure if anyone's seen one in the wild as it were. -- Richard Huxton Archonet Ltd