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

From Kevin Grittner
Subject Re: Massive table (500M rows) update nightmare
Date
Msg-id 4B45A6FE020000250002DEBC@gw.wicourts.gov
Whole thread Raw
In response to Re: Massive table (500M rows) update nightmare  (Leo Mannhart <leo.mannhart@beecom.ch>)
Responses Re: Massive table (500M rows) update nightmare
List pgsql-performance
Leo Mannhart <leo.mannhart@beecom.ch> wrote:

> You could also try to just update the whole table in one go, it is
> probably faster than you expect.

That would, of course, bloat the table and indexes horribly.  One
advantage of the incremental approach is that there is a chance for
autovacuum or scheduled vacuums to make space available for re-use
by subsequent updates.

-Kevin

pgsql-performance by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Air-traffic benchmark
Next
From: "Gurgel, Flavio"
Date:
Subject: Re: Air-traffic benchmark