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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
