Re: [HACKERS] Memory leak in Pl/Python

2016-06-26 Thread Andrey Zhidenkov
It's very strange, but when I use expression 'update test set test = 'test' where id = 1' as argument of plpy.execute() memory do not growing at all... On Sun, Jun 26, 2016 at 9:05 PM, Andrey Zhidenkov wrote: > Thank you for your answer, Tom. > > I've tri

Re: [HACKERS] Memory leak in Pl/Python

2016-06-26 Thread Andrey Zhidenkov
foreign keys, I just created it with script you provided. I think that is a leak because my system became use a swap file and filnally OOM killer kills one of database process and database goes into recovery mode. That is the problem... On Sat, Jun 25, 2016 at 6:15 PM, Tom Lane wrote: > Andrey

Re: [HACKERS] Memory leak in Pl/Python

2016-06-25 Thread Andrey Zhidenkov
tion_name to \'TEST\'') > > for i in range(1, 100): > cursor.execute('select test()') > conn.commit() > > > I see memory consumption in htop and pg_activity tools. > > On Sat, Jun 25, 2016 at 2:00 AM, David G. Johnston > wrote: >> On

Re: [HACKERS] Memory leak in Pl/Python

2016-06-24 Thread Andrey Zhidenkov
cursor.execute('select test()') conn.commit() I see memory consumption in htop and pg_activity tools. On Sat, Jun 25, 2016 at 2:00 AM, David G. Johnston wrote: > On Fri, Jun 24, 2016 at 6:41 PM, Andrey Zhidenkov > wrote: >> >> For example, when I call this procedure

[HACKERS] Memory leak in Pl/Python

2016-06-24 Thread Andrey Zhidenkov
I have postgresql 9.4.8 on my server and I've noticed always growing memory when I use plpython. I've made some tests and find a few situations, when memory leaks. For example, when I call this procedure many times, I can see an always growing memory: create or replace function test() returns bigi