X-Original-To: pgsql-performance@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 4CA86925676 for ; Fri, 23 May 2003 10:38:50 -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 12335-04 for ; Fri, 23 May 2003 10:38:36 -0400 (EDT) Received: from www.pspl.co.in (www.pspl.co.in [202.54.11.65]) by developer.postgresql.org (Postfix) with ESMTP id 6FE6A92584C for ; Fri, 23 May 2003 09:55:26 -0400 (EDT) Received: (from root@localhost) by www.pspl.co.in (8.11.6/8.11.6) id h4NDtPs21017 for ; Fri, 23 May 2003 19:25:25 +0530 Received: from daithan.intranet.pspl.co.in (daithan.intranet.pspl.co.in [192.168.7.161]) by www.pspl.co.in (8.11.6/8.11.0) with ESMTP id h4NDtN221012 for ; Fri, 23 May 2003 19:25:24 +0530 From: Shridhar Daithankar To: pgsql-performance@postgresql.org Subject: Re: postgres on a beowulf? (AMD)opteron? Date: Tue, 20 May 2003 12:14:03 +0530 User-Agent: KMail/1.5.1 References: <20030519132832.6733dd56.gry@ll.mit.edu> In-Reply-To: <20030519132832.6733dd56.gry@ll.mit.edu> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200305201214.03432.shridhar_daithankar@nospam.persistent.co.in> X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/221 X-Sequence-Number: 2000 On Monday 19 May 2003 22:58, george young wrote: > Has anyone run postgres on a beowulf system? > > 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? Postgresql will not run on beowulf at all since it is an MPI system and postgresql can no span a single database across machines (yet). Further it won't even run on mosix because mosix does not support shared memory across machines. > > I have a smallish DB (pgdump|bzip2 -> 10MB), with ~45 users logged in > using local X(python/gtk) postgres client apps. Well, you haven't put how many transactions you do, but in general for that sort of DB, a P-IV/512MB RAM and SCSI disk would be more than enough unless you are doing really exotic things with data.. > [Next question is: has anyone used postgres on an opteron at all??] Well, if it runs linux as good as anything else, postgresql will run as good as anything else..:-) HTH Shridhar