len.walter@xxxxxxxxx (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@xxxxxxxxxxxxxxxx> -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
