Re: Why Does UPDATE Take So Long?

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