Postgres Pro
Downloads
Home   >   mailing lists

Re: Out of memory error when doing an update with IN clause - Mailing list pgsql-general

From Tom Lane
Subject Re: Out of memory error when doing an update with IN clause
Date
Msg-id 15500.1072716596@sss.pgh.pa.us
Whole thread Raw
In response to Out of memory error when doing an update with IN clause  (Sean Shanny <shannyconsulting@earthlink.net>)
Responses Re: Out of memory error when doing an update with IN clause  (Sean Shanny <shannyconsulting@earthlink.net>)
List pgsql-general
Tree view 
Sean Shanny <shannyconsulting@earthlink.net> writes:
> update f_commerce_impressions set servlet_key = 60 where servlet_key in
> (68,69,70,71,87,90,94,91,98,105,106);
> ERROR:  out of memory

How many rows will this try to update?  Do you have any triggers or
foreign keys in this table?  I'm wondering if the list of pending
trigger events could be the problem ...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: An out of memory error when doing a vacuum full
Next
From: Tom Lane
Date:
Subject: Re: An out of memory error when doing a vacuum full