Re: Why Does UPDATE Take So Long? - Mailing list pgsql-general

From Alan Hodgson
Subject Re: Why Does UPDATE Take So Long?
Date
Msg-id 200809301520.10038@hal.medialogik.com
Whole thread Raw
In response to Re: Why Does UPDATE Take So Long?  (Bill Thoen <bthoen@gisnet.com>)
List pgsql-general
On Tuesday 30 September 2008, Bill Thoen <bthoen@gisnet.com> wrote:
> Sorry for the hyperbole; I should have qualified that ridiculous
> statement with "...on my machines." No doubt the problem has something
> to do with configuration, because I don't know much about that. One of
> my machines is running PG 8.1 on Linux Fedora Core 5. It's got an AMD
> 64bit CPU with a GB RAM and plenty of normal disk space

You'll have to expand on the disk space thing ... the problem with updates
is all the random I/O when adding tuples to all the indexes. A good RAID
controller with write-back cache makes updates a lot less painful.


--
Alan

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Free Cache Memory (Linux) and Postgresql
Next
From: Bill Thoen
Date:
Subject: Re: Why Does UPDATE Take So Long?