Re: Commit every N rows in PL/pgsql

len(dot)walter(at)gmail(dot)com (Len Walter) writes:
> I need to populate a new column in a Postgres 8.3 table. The SQL would be something like "update t set col_c = col_a +
> col_b". Unfortunately, this table has 110 million rows, so running that query runs out of memory.

Unnecessary. On Oracle, the typical scenario is "ORA-1562 FAILED TO
EXTEND ROLLBACK SEGMENT."

PostgreSQL doesn't have a rollback segment, so there's nothing to run
out of here. Where Oracle would tend to encourage you to keep your
transactions rather small, PostgreSQL doesn't require you to care about
that.

Big transactions, on PostgreSQL, are really no big deal.
--
select 'cbbrowne' || '@' || 'cbbrowne.com';
http://cbbrowne.com/info/internet.html
"MS apparently now has a team dedicated to tracking problems with
Linux and publicizing them. I guess eventually they'll figure out
this back fires... ;)" -- William Burrow <aa126(at)DELETE(dot)fan(dot)nb(dot)ca>