Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 338F537BA3A for ; Mon, 29 Sep 2008 00:09:02 -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 13068-02 for ; Mon, 29 Sep 2008 00:08:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gatekeeper.Mib-infotech.co.nz (60-234-154-229.bitstream.orcon.net.nz [60.234.154.229]) by postgresql.org (Postfix) with ESMTP id AB6EE37BA3D for ; Mon, 29 Sep 2008 00:08:57 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by gatekeeper.Mib-infotech.co.nz (Postfix) with ESMTP id 3555D10C6EF; Mon, 29 Sep 2008 16:08:55 +1300 (NZDT) X-Virus-Scanned: amavisd-new at mib-infotech.co.nz Received: from gatekeeper.Mib-infotech.co.nz ([127.0.0.1]) by localhost (gatekeeper.mib-infotech.co.nz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id PbgDE7M4hjhO; Mon, 29 Sep 2008 16:08:51 +1300 (NZDT) Received: from [192.168.95.202] (mr-creosote.mib-infotech.co.nz [192.168.95.202]) by gatekeeper.Mib-infotech.co.nz (Postfix) with ESMTPA id 2CE0C10C6EE; Mon, 29 Sep 2008 16:08:51 +1300 (NZDT) Message-ID: <48E046C3.2080001@mib-infotech.co.nz> Date: Mon, 29 Sep 2008 16:08:51 +1300 From: John Huttley User-Agent: Thunderbird 2.0.0.16 (Windows/20080708) MIME-Version: 1.0 To: Scott Marlowe CC: pgsql-performance@postgresql.org Subject: Re: Slow updates, poor IO 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> In-Reply-To: Content-Type: multipart/alternative; boundary="------------050606040202050904050800" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.716 tagged_above=0 required=5 tests=HTML_MESSAGE=0.001, RCVD_IN_SORBS_DUL=1.615, RDNS_DYNAMIC=0.1 X-Spam-Level: * X-Archive-Number: 200809/249 X-Sequence-Number: 31562 This is a multi-part message in MIME format. --------------050606040202050904050800 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Ah yess... actually I can get the Kingston stuff locally. However at the moment I'm happily married and want to keep it that way! Everything is in pairs too. Actually its a lot cheaper than when it first came out, but still a lot more than your corner shop DDR-2 stuff. --John Scott Marlowe wrote: > 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. > > > --------------050606040202050904050800 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Ah yess... actually I can get the Kingston stuff locally.
However at the moment I'm happily married and want to keep it that way!

Everything is in pairs too. Actually its a lot cheaper than when it first came out, but still
a lot more than your corner shop DDR-2 stuff.

--John




Scott Marlowe wrote:
On Sun, Sep 28, 2008 at 8:01 PM, John Huttley <John@mib-infotech.co.nz> 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.


  
--------------050606040202050904050800--