Re: Massive table (500M rows) update nightmare - Mailing list pgsql-performance

From Carlo Stonebanks
Subject Re: Massive table (500M rows) update nightmare
Date
Msg-id hi7okp$2kca$1@news.hub.org
Whole thread Raw
In response to Re: Massive table (500M rows) update nightmare  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Massive table (500M rows) update nightmare
Re: Massive table (500M rows) update nightmare
List 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 by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Array comparison
Next
From: Andreas Kretschmer
Date:
Subject: Re: Massive table (500M rows) update nightmare