Re: Out of memory error when doing an update with IN clause

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sean Shanny <shannyconsulting(at)earthlink(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Out of memory error when doing an update with IN clause
Date: 2003-12-29 20:07:28
Message-ID: 16516.1072728448@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sean Shanny <shannyconsulting(at)earthlink(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2003-12-29 20:07:43 Re: Is my MySQL Gaining ?
Previous Message Joshua D. Drake 2003-12-29 20:04:25 Re: [GENERAL] Is my MySQL Gaining ?