| From: | Alan Hodgson <ahodgson(at)simkin(dot)ca> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Why Does UPDATE Take So Long? |
| Date: | 2008-09-30 22:20:09 |
| Message-ID: | 200809301520.10038@hal.medialogik.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tuesday 30 September 2008, Bill Thoen <bthoen(at)gisnet(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Thoen | 2008-09-30 22:34:39 | Re: Why Does UPDATE Take So Long? |
| Previous Message | Martijn van Oosterhout | 2008-09-30 22:02:32 | Re: Free Cache Memory (Linux) and Postgresql |