Em Fri, 25 Jan 2008 12:46:20 +1300 "Stephen Denne" <Stephen.Denne@xxxxxxxxxxxxxx> escreveu: > A simple update query, over roughly 17 million rows, populating a > newly added column in a table, resulted in an out of memory error > when the process memory usage reached 2GB. Could this be due to a > poor choice of some configuration parameter, or is there a limit on > how many rows I can update in a single statement? > I believe that it is plataform problem. Because on *nix this limit don't occur. But I don't specialist Windows. Kind Regards, -- Fernando Ike http://www.midstorm.org/~fike/weblog ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
