X-Original-To: pgsql-performance@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 1516B923230 for ; Tue, 20 May 2003 05:26:21 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 37750-10 for ; Tue, 20 May 2003 05:26:14 -0400 (EDT) Received: from fuji.krosing.net (sein.itera.ee [194.126.109.126]) by developer.postgresql.org (Postfix) with ESMTP id 19A889232C6 for ; Tue, 20 May 2003 05:15:33 -0400 (EDT) Received: from fuji.krosing.net (lo [127.0.0.1]) by fuji.krosing.net (8.12.8/8.12.8) with ESMTP id h4K9FLlQ001759 for ; Tue, 20 May 2003 12:15:21 +0300 Received: (from hannu@localhost) by fuji.krosing.net (8.12.8/8.12.8/Submit) id h4K8TYUn001517; Tue, 20 May 2003 11:29:34 +0300 X-Authentication-Warning: fuji.krosing.net: hannu set sender to hannu@tm.ee using -f Subject: Re: postgres on a beowulf? (AMD)opteron? From: Hannu Krosing To: gry@ll.mit.edu Cc: pgsql-performance@postgresql.org In-Reply-To: <20030519132832.6733dd56.gry@ll.mit.edu> References: <20030519132832.6733dd56.gry@ll.mit.edu> Content-Type: text/plain Content-Transfer-Encoding: 7bit Organization: Message-Id: <1053419374.1435.4.camel@fuji.krosing.net> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.4 Date: 20 May 2003 11:29:34 +0300 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/187 X-Sequence-Number: 1966 george young kirjutas E, 19.05.2003 kell 20:28: > Has anyone run postgres on a beowulf system? I don't think that postgresql will easyly port to beowulf clusters. > I'm shopping for a new server. One candidate would be a > quad opteron (64-bit AMD "hammer") machine. Another approach might > be a beowulf of single or dual opterons. I imagine the beowulf > would be a bit cheaper, and much more expandable, but what about > the shared memory used by the postgres backends? I gather that > postgres uses shared memory to coordinate (locks?) between backends? > > I have a smallish DB (pgdump|bzip2 -> 10MB), with ~45 users logged in > using local X(python/gtk) postgres client apps. Why do you want such a monster machine for this smallish DB ? Are there any special performance requirements you are not telling us about ? > Will the much slower shared memory access between beowulf nodes be > a performance bottleneck? I guess that it will not run at all ;( -------------- Hannu