Skip site navigation (1) Skip section navigation (2)

Re: Slow updates, poor IO

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "John Huttley" <John(at)mib-infotech(dot)co(dot)nz>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Slow updates, poor IO
Date: 2008-09-29 02:15:05
Message-ID: dcc563d10809281915x6239f86bxdd220eb681c2db96@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Sun, Sep 28, 2008 at 8:01 PM, John Huttley <John(at)mib-infotech(dot)co(dot)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.

In response to

Responses

pgsql-performance by date

Next:From: John HuttleyDate: 2008-09-29 03:08:51
Subject: Re: Slow updates, poor IO
Previous:From: John HuttleyDate: 2008-09-29 02:01:24
Subject: Re: Slow updates, poor IO

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group