Re: [BUGS] memory leaks? using savepoint

2010-12-24 Thread Robert Haas
On Tue, Dec 21, 2010 at 11:09 PM, Tom Lane t...@sss.pgh.pa.us wrote: So if we take the complaint seriously, we'd better patch 8.2 as well. I'm sort of inclined to think we should take the complaint seriously. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL

Re: [BUGS] memory leaks? using savepoint

2010-12-21 Thread Fujii Masao
On Fri, Dec 17, 2010 at 7:27 AM, Tom Lane t...@sss.pgh.pa.us wrote: Tatsuhito Kasahara kasahara.tatsuh...@oss.ntt.co.jp writes: When I tested simple query as following, backend process used much memory and not freed until the backend was finished. # This is reproduced on PostgreSQL8.3

Re: [BUGS] memory leaks? using savepoint

2010-12-21 Thread Tom Lane
Fujii Masao masao.fu...@gmail.com writes: The proposed patch looks very simple. I don't think that applying that patch will cause serious risk. Maybe so, maybe not, but *it won't get tested* to any meaningful degree if it's applied. Unless the bug is fixed, the users who encountered the

Re: [BUGS] memory leaks? using savepoint

2010-12-21 Thread Robert Haas
On Tue, Dec 21, 2010 at 9:26 PM, Fujii Masao masao.fu...@gmail.com wrote: On Fri, Dec 17, 2010 at 7:27 AM, Tom Lane t...@sss.pgh.pa.us wrote: Tatsuhito Kasahara kasahara.tatsuh...@oss.ntt.co.jp writes: When I tested simple query as following, backend process used much memory and not freed

Re: [BUGS] memory leaks? using savepoint

2010-12-21 Thread Tom Lane
Robert Haas robertmh...@gmail.com writes: Are you saying that this problem does not exist in 8.3.0 but does exist in later 8.3.x revs? I believe it dates from Author: Tom Lane t...@sss.pgh.pa.us Branch: master Release: REL8_4_BR [c98a92378] 2008-12-13 02:00:20 + Branch: REL8_3_STABLE

Re: [BUGS] memory leaks? using savepoint

2010-12-21 Thread Fujii Masao
On Wed, Dec 22, 2010 at 11:48 AM, Tom Lane t...@sss.pgh.pa.us wrote: Fujii Masao masao.fu...@gmail.com writes: The proposed patch looks very simple. I don't think that applying that patch will cause serious risk. Maybe so, maybe not, but *it won't get tested* to any meaningful degree if it's

Re: [BUGS] memory leaks? using savepoint

2010-12-21 Thread Fujii Masao
On Wed, Dec 22, 2010 at 3:24 PM, Fujii Masao masao.fu...@gmail.com wrote: On Wed, Dec 22, 2010 at 11:48 AM, Tom Lane t...@sss.pgh.pa.us wrote: Fujii Masao masao.fu...@gmail.com writes: The proposed patch looks very simple. I don't think that applying that patch will cause serious risk. Maybe

Re: [BUGS] memory leaks? using savepoint

2010-12-16 Thread Tom Lane
Tatsuhito Kasahara kasahara.tatsuh...@oss.ntt.co.jp writes: When I tested simple query as following, backend process used much memory and not freed until the backend was finished. # This is reproduced on PostgreSQL8.3 (PostgreSQL8.3.6 - PostgreSQL8.3.12) Hmm ... this test case doesn't appear

[BUGS] memory leaks? using savepoint

2010-12-15 Thread Tatsuhito Kasahara
Hi! When I tested simple query as following, backend process used much memory and not freed until the backend was finished. # This is reproduced on PostgreSQL8.3 (PostgreSQL8.3.6 - PostgreSQL8.3.12) --- BEGIN; SAVEPOINT sp0; INSERT INTO tbl VALUES (1); RELEASE sp0; SAVEPOINT sp1;