"Stephen Denne" <[EMAIL PROTECTED]> writes: > 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?
Do you have any triggers or foreign keys on that table? For that matter, let's see its whole schema definition. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org