Re: [BUGS] BUG #6698: sub-query with join producing out of memory in where clause

2012-06-21 Thread Tom Lane
Heikki Linnakangas writes: > This test case can be further reduced into: > explain analyze > SELECT * FROM generate_series(1,10) i > WHERE (SELECT array(select repeat('a', 1) || i) u1) is not null; > We're leaking the array constructed on each row, in ExecSetParamPlan(). > At line 1000

Re: [BUGS] BUG #6698: sub-query with join producing out of memory in where clause

2012-06-19 Thread Amit Kapila
> I'm not sure what the correct fix is. I suppose we could pfree() the old > value before overwriting it, but I'm not sure if that's safe, or if > there might still be references to the old value somewhere in the executor. It will resolve the current problem but I am also not sure whether it can

Re: [BUGS] BUG #6698: sub-query with join producing out of memory in where clause

2012-06-19 Thread Heikki Linnakangas
On 19.06.2012 04:01, armando.mirag...@stud-inf.unibz.it wrote: The following bug has been logged on the website: Bug reference: 6698 Logged by: Armando Miraglia Email address: armando.mirag...@stud-inf.unibz.it PostgreSQL version: 9.1.2 Operating system: Arch Linux/Ubuntu De

[BUGS] BUG #6698: sub-query with join producing out of memory in where clause

2012-06-18 Thread armando . miraglia
The following bug has been logged on the website: Bug reference: 6698 Logged by: Armando Miraglia Email address: armando.mirag...@stud-inf.unibz.it PostgreSQL version: 9.1.2 Operating system: Arch Linux/Ubuntu Description: Hi everybody! Fact: while I was trying to pr