"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

Reply via email to