Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 66CCC37BA4E for ; Sun, 28 Sep 2008 23:15:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 96312-04 for ; Sun, 28 Sep 2008 23:15:06 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from rv-out-0506.google.com (rv-out-0506.google.com [209.85.198.235]) by postgresql.org (Postfix) with ESMTP id 6A33F37B9B1 for ; Sun, 28 Sep 2008 23:15:07 -0300 (ADT) Received: by rv-out-0506.google.com with SMTP id b25so1718181rvf.43 for ; Sun, 28 Sep 2008 19:15:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=69i0rpJcuxFFGW/EW/GsyB+ZqRjGCboX3jPfMjsuQwE=; b=mc2/CGh9ih8FbhQ39A8U2iKCsU+CcYNg46mkpADQFmCQJeIqV+qKRbd3Towtfg376G IN9VHOhOBF7SHhOhWRjSQTFQtbOoWn3cdy/Mak4El3cKlhd1jPdABPzeY8rm8Uo0TBK3 oG9LNbRqlsJcCvQNueRkJcAECEt4DSPTFXFgM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=EZH4iNXAMmQOSBgRekmNVs1d58YfOuL7j63xI06PzWvIM7z6kcCxVI9DP8G1LtVAbr xZOrW5yna3sXmG39cg6dGp82FNPM88rjlKQN0JdlGOzzxjC+gyG0KJ8EbhW8FH8b+o/N 8js5MFUL/J9Swqo3FyTC3bXYUSh7OClN6yA2w= Received: by 10.140.201.15 with SMTP id y15mr2142590rvf.33.1222654505204; Sun, 28 Sep 2008 19:15:05 -0700 (PDT) Received: by 10.140.248.12 with HTTP; Sun, 28 Sep 2008 19:15:05 -0700 (PDT) Message-ID: Date: Sun, 28 Sep 2008 20:15:05 -0600 From: "Scott Marlowe" To: "John Huttley" Subject: Re: Slow updates, poor IO Cc: pgsql-performance@postgresql.org In-Reply-To: <48E036F4.3040609@mib-infotech.co.nz> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <48DBE587.3050406@mib-infotech.co.nz> <20080926131556.GA1005@commandprompt.com> <48DD6A4A.10209@mib-infotech.co.nz> <48DEB4D4.1020100@mib-infotech.co.nz> <6110.1222612388@sss.pgh.pa.us> <48DFFCDB.3020000@mib-infotech.co.nz> <48E003AC.5000306@mib-infotech.co.nz> <48E036F4.3040609@mib-infotech.co.nz> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/248 X-Sequence-Number: 31561 On Sun, Sep 28, 2008 at 8:01 PM, John Huttley wrote: > Ahh bugger, I've just trashed my test setup. > I've settled on 64Mb shared memory since I've only got 1Gb or RAM and the > system impact of 256M is severe. > Also it uses FB-DIMMS which cost arm+leg+first born http://www.crucial.com/search/searchresults.aspx?keywords=buffered Fully buffered memory there is $56.99 for a 1 Gig stick. That's hardly an arm and a leg. Considering many pgsql DBAs make that in 1 to 3 hours, it's not much at all really. A lot cheaper than pulling your hair out trying to make a db server run on 1 Gig.