Re: Why Does UPDATE Take So Long?

Поиск
Список
Период
Сортировка
От Alan Hodgson
Тема Re: Why Does UPDATE Take So Long?
Дата
Msg-id 200809301520.10038@hal.medialogik.com
обсуждение исходный текст
Ответ на Re: Why Does UPDATE Take So Long?  (Bill Thoen <bthoen@gisnet.com>)
Список 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 по дате отправления:

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Free Cache Memory (Linux) and Postgresql
Следующее
От: Bill Thoen
Дата:
Сообщение: Re: Why Does UPDATE Take So Long?