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

2012-06-21 Thread Tom Lane
Heikki Linnakangas heikki.linnakan...@enterprisedb.com 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

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

2012-06-20 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

[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