On Tue, 17 Dec 2002, mlw wrote:
> update largetable set foo=bar;
>
> Lets also assume that "largetable" has tens of millions of rows.
[..]
> On some of my databases a statement which updates all the rows is
> unworkable in PostgreSQL, on Oracle, however, there is no poblem.
.. provided you have a lot of rollback space, which is
essentially what the datafile growth here is providing.
Matthew.