At 06:32 PM 9/6/2007, Richard Huxton wrote:
>Two other tips for bulk-updates like this:
>1. Do as many columns in one go as you can
>2. Only update rows that need updating
>
>When you've finished, a CLUSTER/VACUUM FULL can be useful too.
How about: make sure you have enough free space because the table
will effectively double in size? Assuming it hasn't already been
updated a few times without vacuuming :).
That's still true right?
It is safe to assume that postgresql will still handle the out of
disk space scenario gracefully - no data corruption - the transaction
fails and that's it?
Regards,
Link.