Re: Massive table (500M rows) update nightmare

Поиск
Список
Период
Сортировка
От Carlo Stonebanks
Тема Re: Massive table (500M rows) update nightmare
Дата
Msg-id hi7okp$2kca$1@news.hub.org
обсуждение исходный текст
Ответ на Re: Massive table (500M rows) update nightmare  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Massive table (500M rows) update nightmare  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: Massive table (500M rows) update nightmare  (Pierre Frédéric Caillaud<lists@peufeu.com>)
Список pgsql-performance
> crank it up more and delay the checkpoints as much as possible during
> these updates.  64 segments is already 1024M.

We have 425M rows, total table size is 78GB, so we can imagine a worst case
UPDATE write is less than 200 bytes * number of rows specified in the update
(is that logic correct?).

Inerestingly, the total index size is 148GB, twice that of the table, which
may be an indication of where the performance bottleneck is.


В списке pgsql-performance по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Array comparison
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Massive table (500M rows) update nightmare