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 16516.1072728448@sss.pgh.pa.us
Whole thread Raw
In response to Re: 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:
> As you can see I had to reduce the number of arguments in the IN clause
> to even get the explain.

You mean you get an out-of-memory error just from EXPLAIN (without
ANALYZE)??  That makes even less sense ... the hash table we identified
before should not be created or filled during EXPLAIN.

            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: [pgsql-advocacy] Is my MySQL Gaining ?