X-Original-To: pgsql-performance@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id DE2A5925986 for ; Mon, 19 May 2003 18:12:40 -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 35800-05 for ; Mon, 19 May 2003 18:12:37 -0400 (EDT) Received: from ll.mit.edu (LLMAIL.LL.MIT.EDU [129.55.12.40]) by developer.postgresql.org (Postfix) with ESMTP id 833EF9259A2 for ; Mon, 19 May 2003 13:28:50 -0400 (EDT) Received: (from smtp@localhost) by ll.mit.edu (8.12.9/8.8.8) id h4JHScAm002525 for ; Mon, 19 May 2003 13:28:38 -0400 (EDT) Received: from sty.llan.ll.mit.edu( ), claiming to be "sty.llan" via SMTP by llpost, id smtpdAAAqYaWYe; Mon May 19 13:28:32 2003 Date: Mon, 19 May 2003 13:28:32 -0400 From: george young To: pgsql-performance@postgresql.org Subject: postgres on a beowulf? (AMD)opteron? Message-Id: <20030519132832.6733dd56.gry@ll.mit.edu> Reply-To: gry@ll.mit.edu Organization: MIT Lincoln Laboratory X-Mailer: Sylpheed version 0.9.0 (GTK+ 1.2.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/186 X-Sequence-Number: 1965 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? I have a smallish DB (pgdump|bzip2 -> 10MB), with ~45 users logged in using local X(python/gtk) postgres client apps. Will the much slower shared memory access between beowulf nodes be a performance bottleneck? [Next question is: has anyone used postgres on an opteron at all??] -- George -- I cannot think why the whole bed of the ocean is not one solid mass of oysters, so prolific they seem. Ah, I am wandering! Strange how the brain controls the brain! -- Sherlock Holmes in "The Dying Detective"