X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 29F1053A06 for ; Wed, 20 Apr 2005 05:55:48 -0300 (ADT) 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 94146-02 for ; Wed, 20 Apr 2005 08:55:44 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.204]) by svr1.postgresql.org (Postfix) with ESMTP id C7C5653209 for ; Wed, 20 Apr 2005 05:55:42 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 34so144089nzf for ; Wed, 20 Apr 2005 01:55:44 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=urwKbh/x0Jn3zfLdn7mWqOx9TRVQbP8N0vtVfOlfqLgrD1J71mPJ22nunZ3nxm9L72rx8kVTFQu+Wzbfso1fWnIu5r+T48UiOwo/i6Yz1u2mcYRBAHY1ad6wPYDDcqeSHuoWLRJwR5fsIbpLdwD+gjlc1CivAXfTuGgdmPE79yQ= Received: by 10.36.59.18 with SMTP id h18mr61267nza; Wed, 20 Apr 2005 01:55:44 -0700 (PDT) Received: by 10.36.22.15 with HTTP; Wed, 20 Apr 2005 01:55:44 -0700 (PDT) Message-ID: <758d5e7f05042001558f24d0f@mail.gmail.com> Date: Wed, 20 Apr 2005 10:55:44 +0200 From: Dawid Kuroczko Reply-To: Dawid Kuroczko To: pgsql-performance@postgresql.org Subject: Re: How to improve db performance with $7K? In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.762 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, FROM_ENDS_IN_NUMS, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/495 X-Sequence-Number: 11892 On 4/19/05, Mohan, Ross wrote: > Clustered file systems is the first/best example that > comes to mind. Host A and Host B can both request from diskfarm, eg. Something like a Global File System? http://www.redhat.com/software/rha/gfs/ (I believe some other company did develop it some time in the past; hmm, probably the guys doing LVM stuff?). Anyway the idea is that two machines have same filesystem mounted and they share it. The locking I believe is handled by communication between computers using "host to host" SCSI commands. I never used it, I've only heard about it from a friend who used to work with it in CERN. Regards, Dawid