"Stephen Denne" <Stephen.Denne@datamail.co.nz> writes:
> A simple update query, over roughly 17 million rows, populating a newly added column in a table, resulted in an out
ofmemory 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