Memory Leak ?

Hi,
I have a C++ application for testing memory leak that connects to
PostgreSQL8.1.3 Database using psqlODBC 08.01.02.00 unicode driver.
I have found some memory leak with the windows performance tool.
I have tried to upgrade the psqlODBC to 08.02.0002 ,but the leak still
exists.

The piece of my Code is like this:
SQLAllocHandle (SQL_HANDLE_ENV, NULL, &henv);
SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);
SQLConnect (hDBC, szDSN, SQL_NTS, szUID, SQL_NTS, szPasswd, SQL_NTS);
SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);
while( i < 10){
SQLPrepare(hstmt,(SQLCHAR*)szSql, SQL_NTS);
SQLBindParameter(......);
......
SQLExecute(hstmt);
SQLFreeStmt(hstmt,SQL_RESET_PARAMS);
}
SQLEndTran(SQL_HANDLE_DBC,(SQLHDBC)hdbc, SQL_COMMIT);
SQLFreeStmt(hstmt, SQL_CLOSE);
SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
SQLDisconnect(hdbc);
SQLFreeHandle(SQL_HANDLE_DBC, hdbc);

my Env: VC.net, windows2003 server, PostgreSQL8.1.3

some of you have faced similar issue for memory leak?
or I have made some misstake in Using the Odbc function?
If you could help me, that would be great!

thanks,
zhao




---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: Memory Leak ?

> SQLAllocHandle (SQL_HANDLE_ENV, NULL, &henv);
> SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);
> SQLConnect (hDBC, szDSN, SQL_NTS, szUID, SQL_NTS, szPasswd, SQL_NTS);
> SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);
> while( i < 10){
> SQLPrepare(hstmt,(SQLCHAR*)szSql, SQL_NTS);
> SQLBindParameter(......);
> ......

Please could you send us the exact szSql and their BindParameters
so we don't have to make steps into dark? BTW table structure and
some sample data could help too.
It speeds up finding the problem.

> SQLExecute(hstmt);
> SQLFreeStmt(hstmt,SQL_RESET_PARAMS);
> }
> SQLEndTran(SQL_HANDLE_DBC,(SQLHDBC)hdbc, SQL_COMMIT);
> SQLFreeStmt(hstmt, SQL_CLOSE);
> SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
> SQLDisconnect(hdbc);
> SQLFreeHandle(SQL_HANDLE_DBC, hdbc);

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: Memory Leak ?

to:Luf

Thanks for you response.
my test program is below ,and I expect for you help .

Table structure:
*************************************
CREATE TABLE TestLeak
( c1 int4,
c2 text,
c3 int4
)
*************************************

my program is like this:
*************************************
void testInsert(){
char *sqlInsert=3D"insert into TestLeak values(?,?)";
char szTmp[STR_LEN];//STR_LEN =3D 132
SQLINTEGER sOrderID=3D0 ,cbValue =3D SQL_NTS;=09
SQLINTEGER cbOrderID =3D 0 ;
int i;

//initialize
memset(szTmp,0,STR_LEN);
memset(szTmp,'a',STR_LEN-1);//insert 'a'

//INSERT
for(i =3D 0 ; i < count ; i++)
{
retcode =3D SQLPrepare(hstmt,(SQLCHAR*)sqlInsert,SQL_NTS);
SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT,
SQL_C_SLONG,SQL_INTEGER, 0, 0, &sOrderID, 0, &cbOrderID);
SQLBindParameter(hstmt, 2, SQL_PARAM_INPUT, SQL_C_CHAR,
SQL_CHAR,STR_LEN, 0, &szTmp, 0, &cbValue);
SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT, SQL_C_SLONG,
SQL_INTEGER, 0, 0, &sOrderID, 0, &cbOrderID);
sOrderID =3D i;
retcode =3D SQLExecute(hstmt);
if( RC_NOTSUCCESSFUL(retcode))
{
exit_nicely();
}
}
retcode =3D SQLFreeStmt(hstmt,SQL_RESET_PARAMS);
SQLEndTran(SQL_HANDLE_DBC,(SQLHDBC)hdbc, SQL_COMMIT);
}
************************************************************ ******

thanks,
zhao

Ludek Finstrle wrote:
>> SQLAllocHandle (SQL_HANDLE_ENV, NULL, &henv);
>> SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);
>> SQLConnect (hDBC, szDSN, SQL_NTS, szUID, SQL_NTS, szPasswd, SQL_NTS)=
;
>> SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);
>> while( i < 10){
>> SQLPrepare(hstmt,(SQLCHAR*)szSql, SQL_NTS);
>> SQLBindParameter(......);
>> ......
>=20
>=20
> Please could you send us the exact szSql and their BindParameters
> so we don't have to make steps into dark? BTW table structure and
> some sample data could help too.
> It speeds up finding the problem.
>=20
>=20
>> SQLExecute(hstmt);
>> SQLFreeStmt(hstmt,SQL_RESET_PARAMS);
>> }
>> SQLEndTran(SQL_HANDLE_DBC,(SQLHDBC)hdbc, SQL_COMMIT);
>> SQLFreeStmt(hstmt, SQL_CLOSE);
>> SQLFreeHandle(SQL_HANDLE_STMT, hstmt);
>> SQLDisconnect(hdbc);
>> SQLFreeHandle(SQL_HANDLE_DBC, hdbc);
>=20
>=20
> Regards,
>=20
> Luf
>=20
> ---------------------------(end of broadcast)--------------------------=
-
> TIP 2: Don't 'kill -9' the postmaster
>=20

--=20

以上、よろしだãŠ=E9=
¡˜ã„いたします ã€=82
*******************************************
NEC-CAS 基盤ソフトウ゠§ã=
‚¢é–‹ç™ºæœ¬éƒ¨ 第二開ç=
™ºéƒ=A8
趙　新
E-mail:zhaox@necas.nec.com.cn
Telel :8-0086-22-425
外　ç·=9A:(010)8233-4433-425
*******************************************

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: Memory Leak ?

zhaoxin wrote:
> to:Luf
>
> Thanks for you response.
> my test program is below ,and I expect for you help .

Could you try the dll at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html ?
Recently I found a memory leak in some combination of connection
options.

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: Memory Leak ?

TO: Hiroshi Inoue

> Could you try the dll at
> http://www.geocities.jp/inocchichichi/psqlodbc/index.html ?
> Recently I found a memory leak in some combination of connection
> options.
I have tested the driver downloaded from this link .
but memory leak seems still exist .

regards,
zhao

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: Memory Leak ?

zhaoxin wrote:
> TO: Hiroshi Inoue
>
>> Could you try the dll at
>> http://www.geocities.jp/inocchichichi/psqlodbc/index.html ?
>> Recently I found a memory leak in some combination of connection
>> options.
> I have tested the driver downloaded from this link .
> but memory leak seems still exist .

Could you tell me your connection string ?

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: Memory Leak ?

TO:Hiroshi Inoue


>>> Could you try the dll at
>>> http://www.geocities.jp/inocchichichi/psqlodbc/index.html ?
>>> Recently I found a memory leak in some combination of connection
>>> options.
>>
>> I have tested the driver downloaded from this link .
>> but memory leak seems still exist .
>
>
> Could you tell me your connection string ?

My connection string is like this (with ODBC default settings):

SQLAllocHandle (SQL_HANDLE_ENV, NULL, &henv);

SQLSetEnvAttr(henv,SQL_ATTR_ODBC_VERSION,
(SQLPOINTER)SQL_OV_ODBC3,SQL_IS_INTEGER);

SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);

SQLSetConnectOption(hdbc,SQL_AUTOCOMMIT, SQL_AUTOCOMMIT_OFF);

SQLConnect(hdbc,(SQLCHAR*)szDSN, (SQLSMALLINT)strlen(szDSN),
(SQLCHAR*)szUID, (SQLSMALLINT)strlen(szUID),
(SQLCHAR*)szAuthStr, (SQLSMALLINT)strlen(szAuthStr));

SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: Memory Leak ?

zhaoxin wrote:
> TO:Hiroshi Inoue
>
>
>>>> Could you try the dll at
>>>> http://www.geocities.jp/inocchichichi/psqlodbc/index.html ?
>>>> Recently I found a memory leak in some combination of connection
>>>> options.
>>>
>>> I have tested the driver downloaded from this link .
>>> but memory leak seems still exist .
>>
>>
>> Could you tell me your connection string ?
>
> My connection string is like this (with ODBC default settings):

Could you tell me the option settings concretely ?

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: Memory Leak ?

> >>>Could you try the dll at
> >>> http://www.geocities.jp/inocchichichi/psqlodbc/index.html ?
> >>>Recently I found a memory leak in some combination of connection
> >>>options.
> >>
> >>I have tested the driver downloaded from this link .
> >>but memory leak seems still exist .
> >
> >
> >Could you tell me your connection string ?
>
> My connection string is like this (with ODBC default settings):
>
> SQLConnect(hdbc,(SQLCHAR*)szDSN, (SQLSMALLINT)strlen(szDSN),
> (SQLCHAR*)szUID, (SQLSMALLINT)strlen(szUID),
> (SQLCHAR*)szAuthStr, (SQLSMALLINT)strlen(szAuthStr));

Hiroshi needs to know the value for szDSN.

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: Memory Leak ?

>>>Could you tell me your connection string ?
>>
>>My connection string is like this (with ODBC default settings):
>>
>> SQLConnect(hdbc,(SQLCHAR*)szDSN, (SQLSMALLINT)strlen(szDSN),
>> (SQLCHAR*)szUID, (SQLSMALLINT)strlen(szUID),
>> (SQLCHAR*)szAuthStr, (SQLSMALLINT)strlen(szAuthStr));
>
>
> Hiroshi needs to know the value for szDSN.
>
ok,I see .
my connection string is below:
***************************
char szDSN[20];
char szUID[20];
char szAuthStr[20];
....
sprintf(szDSN,"postgre_8.02\0");
sprintf(szUID,"test\0");
sprintf(szAuthStr,"test\0");
....
***************************
is there some problem here ?


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: Memory Leak ?

Fri, Jun 16, 2006 at 05:03:14PM +0800, zhaoxin wrote:
> my connection string is below:
> ***************************
> char szDSN[20];
> char szUID[20];
> char szAuthStr[20];
> ...
> sprintf(szDSN,"postgre_8.02\0");
> sprintf(szUID,"test\0");
> sprintf(szAuthStr,"test\0");
> ...
> ***************************
> is there some problem here ?

I see no problem. We only want to simulate your situation.
We need to know the exact psqlODBC state.

Please could you send us mylog output?

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: Memory Leak ?

This is a multi-part message in MIME format.
--------------020406050501050108070406
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


> I see no problem. We only want to simulate your situation.
> We need to know the exact psqlODBC state.
>
> Please could you send us mylog output?

I add the mylog file to the attachment .
I hope it is helpful .

>
> Regards,
>
> Luf
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>

--------------020406050501050108070406
Content-Type: text/plain;
name="mylog_1372.log"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline;
filename="mylog_1372.log"

[2784]globals.extra_systable_prefixes = 'dd_;'
[2784]aszKey='DSN', value='postgre_8.02'
[2784]copyAttributes: DSN='postgre_8.02',server='',dbase='',user='',passwd='xxxxx' ,port='',onlyread='',protocol='',conn_settings='',disallow_p remature=-1)
[2784]getDSNinfo: DSN=postgre_8.02 overwrite=0
[2784]globals.extra_systable_prefixes = 'dd_;'
[2784]rollback_on_error=1
[2784]globals.extra_systable_prefixes = 'dd_;'
[2784]calling getDSNdefaults
[2784]checking libpq library
[2784]hmodule=63100000
[2784]libpq_exist=1
[2784]DETACHING PROCESS

--------------020406050501050108070406
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

--------------020406050501050108070406--

Re: Memory Leak ?

This is a multi-part message in MIME format.
--------------030000060607040504040704
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit



zhaoxin wrote:
>
>> I see no problem. We only want to simulate your situation.
>> We need to know the exact psqlODBC state.
>>
>> Please could you send us mylog output?
>
>
> I add the mylog file to the attachment .
> I hope it is helpful .

sorry , the file I sended maybe is incorrect.
send again .

Regards,
zhao

--------------030000060607040504040704
Content-Type: application/octet-stream;
name="mylog_1792.zip"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="mylog_1792.zip"

UEsDBBQAAAAIADCy0DSyPg2EUBYAAIADAgAOAAAAbXlsb2dfMTc5Mi5sb2ft
nW1z2kjWhr/nV/SnxX4KuySB8cuGbDGYcVzj2B5DpnYn5VIJqQFtZImRhJPs
r39Ot16QhMC8hOAht2dqDK3T3aePjrrvqyWPPmnnWv1x6Hh9wwmO+dfQN/Tg
WxAafYfrY58P7K88YE1WsSz9n5U3n6T5p0/d329ajuOZ7w3XcvjjY1T+f/TD
bJfdX7Xur3Vp0HGfGRW+SQwY/2qHBYMLNh5xsmuy2kA7PVGoQrajLg/JqBWG
/uMjM8KwqSlKtfaCK5ke2p7rcjO8YNwNuW+7w+Pj4zcZh8tMc/5UmUnl8mtt
MFDiup1b3aCgmFEV23MvWMCdwQu1WPRDNblFg2E2a8aWR+9KOg0+2Y+FA8nA
adxXPLx2B95BTTnMDTsuz414IEp638a8eXr6ptR43KwotWNFqVSZw13h1rPh
TLj0r//B+NpUtcJpicMVnxpV0XIN5w3YwPPjUFwIU6bMMb4bR8FMfGeDqIQC
IKo93xu+8URfXqrf+ti7a999+HDdu2CU1W5gmKFOiR1OgqZKYxuLdprZcMYN
5EK5IHmGPLzs3toydvShOfaCcOhz/eyY3PSeuf/Ft0PeVBPz1a4x33OcvmF+
1j1X577v+c2jNVsyDccRcYz8tfjAmDhhEB9st5MMLhtiEDhPnsWblh2ILuJS
z7eHtms4+uLKpWbkgfAvGyvKt4D7FC9xgC5CwxnRUSode34oyk7qNa1G3y2D
BmoEPNNAQMUTqu0aT7I45FFNIwi+eL7VrHwVP2kk4muVghF6LBzxpOPAMz/z
cOr69KIuNWTBxDQ5p0s4DZT9P+4NGJ0JP5yMqX9p1mTnZ4kBxUc2ZEzov25o
m4Zsvk8D/ny8jFHUaRAMJo7zLc1BctRglleokeQQNyymnZ5VWZQyeuS+3p8M
BtwXPjfrynkjthZNsKEXsspDEjDD539lLrWpRbfyY4quvCgg99HppouUPQvP
KShBKNLtglXOjtXjWlKhI64JM6TJtaSKO3nqcz+q8h29/W226M/K9Pqis2rR
f0KRd0HZhZJZgLrh01ILVWQ3svpmusDQVUSF8utZXzub9i9WKTHv8SdqN1qk
mtkqzVyFqJNffc5nfBllrKvJtJzOb78/8IAmlrgGu+x0ew8f2727h/h4t63b
rh3qkdlB1MxheuySrlx/Yoaen7oY9SO+HL3zZS2xFkXfxdCbuZW1dX+pD8ht
XU7sFGjWue11HqIKzbraqDfqySCvF9pSz2Yjjcdlq9d6wdhS3pSOo/Pv6970
PDie93kypl+lM61Ikr8m3P92cHghl/70HMnSZoV6oymJebZVZeG3sZgI6Rdn
A997YuOhLr98GXGfi8PJhOh4lcpMFxc0Y7hiTnMtMRfKstiI1NvvD2LVS0YR
l0vZVnpETjKnp8vNMVkfxIViW8LJXiXNIX3AQ3Ok0yTqcAq1OfEDTy4MleTM
R0Xpwk3XtD6wuWOJdS8RIA+d1uX17RVr9Xq9/9x/uLtMzsK1LtyNK1ww+VuE
qlmhuFIXhhXaVlNryE+R81WhOSmitBDSEswOfO5UqeSweaBq9dNq4+SkVj9c
v9/MqVyrf/X8cF7waBUMWbHr0nh9aN3c3LVJJ4mauuhXqi1xtcWfG4oy7cYl
5RH1ckFyvye7IyPKC07zQiw3wpHvTYYjGqzpTVwxMVFzkYPRPJxZWCgrGC2f
sknm2OT20RGLp0zq4SOt+bQOU8sB9RiO7CBSw+eawrqdm047ucr0gnOVdiXu
MvRCwxE9sn/IBqJQZVwo1BTSS+Sq730J2FvWbrXfd/Tu9Z8dOiTL5HBMwxyl
8ZrTEkWfjCwm9IHrfZnvKYmju9sOO0jiRS0eLrxs/qwsOfWmx6Or23S8gOvR
jFq0EBMde+JPnv+NrKvxyWsqi+y8yUwzLzkip5NFfkiDmfqJHHAMf8iZ1/9v
PCNesKPz8/OZqdYcGVIM+JRKZZNuhF0T1zaFyFWm9VO56vNw4rslq3W7xEJJ
TD7FcHZpG8MHbj4+FoErPjBlHHH5NzVqzEzX08ySH3fWERgQrfrx4sDeKu/S
S0hEnHwnmR8BQ/GASZkY8ujYUzCMD9MnOb1m5/m5xsnRYh9UdJUUxRGhjHc9
utIoMHNHT62JwatKAWp/nbhSfAePm7KuVit2nrLu29uPNzfvYtjVEtjVEtjV
3mzcd33jvl/e3Ni9YEySXfQQ7wRE3krNVTvXxPlVlWIsEvPEOGozZ7tcy+oK
Lasrtayt0LK2UsszWbmg5VomEe99TiKU59IgLnshCVKrbu9DT5fLfavXuRS7
TONvmR5+sV1L7rBwaizXT+5IWW+0mollapzY6H1b6ssM8zCynspmoe5T60A3
RJ5S1llC5QuZEuntdEKUk8/cTvJO2Mt70Vjfi5JeCrGYhGLTQrdzs0S+f0tZ
PwqZ5t8sOFfCz2bSjZybVFrZ2/LTkUpic9D9y5Hf6mIKanvOJR+ICna/axqO
2AKMtf6w/4ecqlRtwBuiRTMqEBJRFNWjXRrdoMXgKzczqujVJJeaC6u2o+R6
2YvtJtcSUVgludTy5FIzqaVmUksVZ2dxcpmzyXX2+pNLy4W1tqPketmL7SbX
ElFYJbm03c9cHSqahPmFNy7LJVRejKQWpsMNn0l5HBRJ4nbydB9vLM1mZrdN
fGR+MwWVFxRZXrattE1VajzdqxJu61/scKRnzi5hmuc8c+tCKgaRC6lDLGlE
3mZJ7rEokbqtNWLRWLHdgPvEri6hfI8H4Q03Puv1SPsGB/+q0j+HCYY8RL3d
uVzG5kLuchEZi1N9GJ350DtITv5hs75UPbVQS92wN8bk0DKxkjdfFg9UqXYq
RvpTqSrpoMV9wT7BtNjr6PMhwbqR3rkS29dy0zuJeeH8R7cV7bASsNu7HlWM
twuzWTMj3V/edFx3KNvca6zVNtlrbJe56H1mR3Kz6Ij90rm6vi0xSXajzCcr
6k40Jo3LGly+v+vbbuehxxSmLtvptEZZ0+l+BH2abpMtt4/UFTcrCjv01biF
w+V2eL4npfx6fXvdfS8gJZ4DV50Uf5p9sUX3Vr7nyrChztpXONlXXQxJtl+S
rAFJVjpQtaBj1Kwk+/Gyar47L7fcbf3Rub+7vu0xvfPvTlvv/nGvK0rk3o8Q
Z5q6TXGWjm5ZrZRW+N5S6aeRFltNFm2bybJnyvrla/+hc9NpdTs7uvLV822e
zHhsy57J2Hy503jOz2en7p/7qgfGAeOAccA4YBww7m+DcVqBm7TdYtx8d4Bx
wDhgHDAOGAeMA8btXdSBccA4YBwwDhi3FsbVCtxU2y3GzXcHGAeMA8YB44Bx
wDhg3N5FHRgHjAPGAeOAcWthXL3ATfXdYtx8d4BxwDhgHDAOGAeMA8btXdSB
ccA4YBwwDhi3FsadFLjpZLcYN98dYBwwDhgHjAPGAeOAcXsXdWAcMA4YB4wD
xq2FcY0CNzV2i3Hz3QHGAeOAccA4YBwwDhi3d1EHxgHjgHHAOGDcWhh3WuCm
091i3Hx3gHHAOGAcMA4YB4wDxu1d1IFxwDhgHDAOGLcWxp0VuOlstxg33x1g
HDAOGAeMA8YB44Bxexd1YBwwDhgHjAPGrYVx5wVuOt8txs13BxgHjAPGAeOA
ccC47WKcVFiu1SP58BhLrEQKxazWi99of8FGVt9Mc3HE3ed0FEXLJN08VyYw
q6v1E7XWoHN89+HDdckkPS/V59lvIa3PtpnW0TiWzer5o0ZSY2/ilUZ9X/cm
NmD4+gzrnpivZm9ifYY/OZtleAUM/30ZXokYvq4mDD8ZU4B5FiNp7WCmRqH+
F/sy4j5npiq+LAfyPwjIF3jdqfTTn0p2BEqGyo0+zWDUI+vzIc2QRhQkEhk2
aQv6dxrFwhndEtFvNJ5t6pfaVoH8l87V9e2y8kUalzW4fH8fxTXWYdqyXSb2
r5DnoEagRqBGoEb+1mqk8fOqEXXL9wg28gk3CnCjYJ9uFCjbTJY9EpW4SYCb
BNhP3euog2BAMCAYEMzmBKO9QoIpEVUgGBAMCAYEA4IBwYBg9iDqIBgQDAgG
BLM5wdReIcHUQDAgGBAMCAYEA4IBwexl1EEwIBgQDAhmc4Kpv0KCqYNgQDAg
GBAMCAYEA4LZy6iDYEAwIBgQzOYEc/IKCeYEBAOCAcGAYEAwIBgQzF5GHQQD
ggHBgGA2J5jGKySYBggGBAOCAcGAYEAwIJi9jDoIBgQDggHBbE4wp6+QYE5B
MCAYEAwIBgQDggHB7GXUQTAgGBAMCGZzgjl7hQRTokJAMCAYEAwIBgQDggHB
7EHUQTAgGBAMCGZzgjl/hQRzDoIBwYBgQDAgGBDM9gkGL43HS+P3LqmB5cDy
74bl6+OrZc7gKwe+bufl6rWTBF8vSRKQtBM0mSWv1cF1ZQR9uefX/Dr0Fbzf
5jq8Xy8/j4O6NJck9q+QS7CqYlXFqvqTrKqNv9Oquu3Xeq/gATZtsWmLTduf
Txxh0xabttjf2uuoQ4lDiUOJL+5526+nXsEDKHEocShxKHEocShxKPG9ijqU
OJQ4lPjinrf9muUVPIAShxKHEocShxKHEocS36uoQ4lDiUOJL+55268LXsED
KHEocShxKHEocShxKPG9ijqUOJQ4lPjinrf92tsVPIAShxKHEocShxKHEocS
36uoQ4lDiUOJL+55269vXcEDKHEocShxKHEocShxKPG9ijqUOJQ4lPjinrf9
GtIVPIAShxKHEocShxKHEocS36uoQ4lDiUOJL+5526/TXMEDKHEocShxKHEo
cShxKPG9ijqUOJQ4lPjinrf9WsgVPIAShxKHEocShxKHEt+eEsdLIPESSCR1
aVKLVn6lAXRJ5+UEf1KYE+qjjBykgNyNxcvc0rZAozuj0eQ0vjdcy+GP655J
dcm4LBoXHbvkyeRzkY5F9iO+HL2LIijANfqeyc64/db95YLI1NVGvVE/m287
Dcz1woZEiBtn802n7XzPk1UIUGFT4dIOxBohMGzg+SwKS3w+L0Pzzp0a5Nal
afH8/YasTfp6xnZbF8TuTsbTtYXK2lFZOr7M2TEGIinIhtrwEy+6d+3fMuPK
mYpjzCoek5fMtKe5nspFcMbLWbt02ZgO+8Xroj0/ZHIzjmJRYjybsNF10s6e
2bLILRnaVeKVnoyyYjnrTbcuRp5j0WJfaG/mpJWMePnYzoat4z6L+D5HlHF6
ojCymAakc1sWNGGX9TNnRf6I1pLZijFSIVmvWo7jmYvckgbkV8YT+iQ7yhtc
sPGo4Hq2oy4PyagVhv7jIzPCsKkpSrX2giuZHl5KvzLTnD/VSHo2WS6LKFiG
ZenxlUETezQNv1Ar2g1iVJNbNBhms2ZsSVP0bKfBJ/uxcCAzjV3x8NodeAc1
5TA37Lg8N+KBKJH7mqenb0qNx82KUjtWlEq0zUYePMv9TeFK/4PxtalqhdMS
hys+Naqi5RrOG2Qm2gthypQ5xtEqOfU9WTdFLlK1Z7l/l9lMnVe/9bF3F8nf
i/StuMlOokpjk6tGTqLFDeRCuSB5hjy87N7aMnb0oTn2gnDoc/3smNz0nrn/
xbdDni73ERIEx/wreaMH38iVPom4sc8H9lcpwSuUTv9MNLbvOU7fMD/rnqvL
bd7m0ZotmYbjiDhG/lp8YJAwSOYnMeXPH2IQOE+exZuWHYgu4lLPt4e2S3iz
uHKpGXkg/MvGqiLmI/85Aha6CA1nREepdEwLnyg7qde0WiXaTe8bAc80EFDx
hGq7xpMsDnlU0wiCL55vNStfxU8aifhapWDQmhyOeNJxxGlT16cXdakhCyam
yTldwmmgiO28gVgF/HAypv6lWZNliSqUDRkT+q8b2qYhm+/TgD8fL2MUdRoE
g4njfEtzkBw1aPEu1Mhtl50uyaOiCUl7lYckYIbP/8pcalOLbuXHFF15UUDu
o9NNFyl7Fp7LV1uLdLtglbNj9Tj9/4R3xDVhhjS5llRxJ099cQ9IVPmO3v42
W5Siclts4xFMx3ReeksmswDNIMSchSqyExIpXWCimyKsQIFCQNJkUETFbJX8
nYefAmdWIJaVoGQ+ddB5cDzv82RMv0pn2hc3sOLbRp5tVVn4bSwmQvrFoztA
46Euv0S3f+hjMiE6XuVH7Hmdnm6y59WbbizpAx6aI50mUYdTqM2JH3hyYagk
Zz4qShduuqb1gc0dS6x7iQB56LQur2+vWKvX6/3n/sPdZXIWrnXhblzhgsnf
IlTNCsWVujCs0LaaWkN+ipyvCs1JEaWFkJZgduBzp0olh80DVaufVhsnJ7X6
4fr9Zk7lWv2r54fzgkerILFHoevSeH1o3dzctUkniZq66FeqLXG1xZ8bynS3
R3dJeUS9iN2jnuyOjCgvOM0LsdwIR743GY4u4t0isYzQQelgNA9nFhbKCkbL
p2ySOTa5fXSUbmja7kda82kdppYD6jEc2dObKazbuem0k6tMLzgntkzjmHih
4Yge2T9kA1GoMi4UagrpJXLV974E7C1rt9rvO3r3+s8OHZJlcjimYY7SeM1p
iaJPRhYT+sD1vsz3lMTR3W2HHSTxohYPF142P99+bCIHHMMfcub1/xvPiBfs
6Pz8fGaqNUeGFAM+pVLZpBth18S1TSFylWn9RdsdBS7IWCg5aieuurSN4QM3
Hx+LwBUfmDKOuPybmnjwKF1PM0t+3FlHYEBuY4S9Vd4VN0dI5kfAUDxgUiaG
PDr2FAzjw/RJTq+F/Ypy4+RosQ8qukqK4ohQxrseXWkUmLmjp9bE4FWlALW/
TlwpvoPHTVlXqxU7T1n37e3Hm5t3MexqCexqCexqbzbuu75x3y9vbuxeMCbJ
LnqIdwIib6Xmqp1r4vyqSjEWiXliHLWZs12uZXWFltWVWtZWaFlbqeWZrFzQ
ci2TiN/rUUe53Ld64llH8exVpocNHrej1UwsU+kTXnrflvoywzyMrKeyWaj7
zPNghshTyjpLqHwhUyK9nU6IcvKZ20neCXt5Lxrre1HSSyEWk1A+AmjnZol8
/5ayfhQyzb9ZcK6288xjQ5l55rFRX/jM46tILjUXVm1HyfWyF9tNriWisEpy
qeXJpWZSS82klirOzuLkmn2gVsTytSeXlgtrbUfJ9bIX202uJaKwSnJpu5+5
8LT2yk9rK/HT2o3kaW3bDbhP7OoSymeeWJbaNzj4V5X+Odz0ce3F9dRCLXXD
3uY8HL54oEq1UzHSn0pVSQct7gsmDwz0+ZBg3UjvXInta7npncS8cP639JT5
ukPZ5l5jrbbN5+t+6Vxd35aYlD5eJ43LGly+v+vbbuehx5T0RvuLnU5rvMJn
jvEHWXv9CNzf5g+yfiic7KsuhiTbL0nWgCQrHaha0DFqVpL9eFk13x38JR/+
km+f/pJP22ay7Jmyxl/z4a/58P/V2OuoA+OAccA4YBwwbi2M0wrcpO0W4+a7
A4wDxgHjgHHAOGAcMG7vog6MA8YB44BxwLi1MK5W4KbabjFuvjvAOGAcMA4Y
B4wDxgHj9i7qwDhgHDAOGAeMWwvj6gVuqu8W4+a7A4wDxgHjgHHAOGAcMG7v
og6MA8YB44BxwLi1MO6kwE0nu8W4+e4A44BxwDhgHDAOGAeM27uoA+OAccA4
YBwwbi2MaxS4qbFbjJvvzmvFuJpaVx4vO71W+714w8P9w1270+2++X9QSwEC
FAAUAAAACAAwstA0sj4NhFAWAACAAwIADgAAAAAAAAABACAAAAAAAAAAbXls
b2dfMTc5Mi5sb2dQSwUGAAAAAAEAAQA8AAAAfBYAAAAA

--------------030000060607040504040704
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

--------------030000060607040504040704--

Re: Memory Leak ?

zhaoxin wrote:
>
>
> zhaoxin wrote:
>>
>>> I see no problem. We only want to simulate your situation.
>>> We need to know the exact psqlODBC state.
>>>
>>> Please could you send us mylog output?
>>
>>
>> I add the mylog file to the attachment .
>> I hope it is helpful .
>
> sorry , the file I sended maybe is incorrect.
> send again .

Were the data inserted properly when the log was taken ?
Judging from the log, the application seems to have
finished in the middle(6-th data) of the execution.

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: Memory Leak ?

To:Hiroshi

> Were the data inserted properly when the log was taken ?
> Judging from the log, the application seems to have
> finished in the middle(6-th data) of the execution.
>
sorry , mybe not properly .
My program is like this :
loop :
connect db ;
insert 10 reocrds ;
commit;
update this 10 records ;
commit;
delete this 10 records ;
commit;
disconnect db;
end loop;
the loop is not terminable.
and I interrupted the program unproperly and took the log.
but I am sure it have run over one loop.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: Memory Leak ?

zhaoxin wrote:
> To:Hiroshi
>
>> Were the data inserted properly when the log was taken ?
>> Judging from the log, the application seems to have
>> finished in the middle(6-th data) of the execution.
>>
> sorry , mybe not properly .
> My program is like this :
> loop :
> connect db ;
> insert 10 reocrds ;
> commit;
> update this 10 records ;
> commit;
> delete this 10 records ;
> commit;
> disconnect db;
> end loop;
> the loop is not terminable.

Well what do you mean by *Memory Leak* ?
Does the memory usage grow while repeating the loop ?

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: Memory Leak ?

Toï¼=9AHiroshi

>=20
> Well what do you mean by *Memory Leak* ?
> Does the memory usage grow while repeating the loop ?
>=20
yes , in my test , I found memory usage keep growing .
bwt I used windows performance tool.

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: Memory Leak ?

zhaoxin wrote:
> Toï¼=9AHiroshi
>=20
>>
>> Well what do you mean by *Memory Leak* ?
>> Does the memory usage grow while repeating the loop ?
>>
> yes , in my test , I found memory usage keep growing .
> bwt I used windows performance tool.

I can't see the growth here with a similar test case.
Could you send me the test program(exe) ?

regards,
Hiroshi Inoue


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Re: Memory Leak ?

This is a multi-part message in MIME format.
--------------030607050502010804070508
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

To:Hiroshi Inoue

> I can't see the growth here with a similar test case.
> Could you send me the test program(exe) ?
ok , I add my cpp file to the attachment .
I hope you can help me .thanks

Regards,
zhao

--------------030607050502010804070508
Content-Type: text/plain;
name="TestOdbc.cpp"
Content-Transfer-Encoding: base64
Content-Disposition: inline;
filename="TestOdbc.cpp"

I2luY2x1ZGUgPHN0ZGlvLmg+DQojaW5jbHVkZSA8c3RyaW5nLmg+DQojaW5j
bHVkZSA8d2luZG93cy5oPg0KI2luY2x1ZGUgPHNxbC5oPg0KI2luY2x1ZGUg
PHNxbGV4dC5oPg0KI2luY2x1ZGUgPHNxbHR5cGVzLmg+DQojaW5jbHVkZSA8
b2RiY3NzLmg+DQojaW5jbHVkZSA8cHJvY2Vzcy5oPg0KI2luY2x1ZGUgPHRp
bWUuaD4NCiNkZWZpbmUgUkNfU1VDQ0VTU0ZVTChyYykgKCgocmMpID09IFNR
TF9TVUNDRVNTKSB8fCAoKHJjKSA9PSBTUUxfU1VDQ0VTU19XSVRIX0lORk8p
KQ0KI2RlZmluZSBSQ19OT1RTVUNDRVNTRlVMKHJjKSAoIShSQ19TVUNDRVNT
RlVMKHJjKSkpDQoNClNRTEhFTlYgICAgICAgIGhlbnYgPSBTUUxfTlVMTF9I
RU5WOw0KU1FMSERCQyAgICAgICAgaGRiYyA9IFNRTF9OVUxMX0hEQkM7DQpT
UUxIU1RNVCAgICAgICBoc3RtdD0gU1FMX05VTExfSFNUTVQ7DQoNCmNoYXIg
c3pTcWxTdGF0ZVtTUUxfTUFYX01FU1NBR0VfTEVOR1RIXSwgc3pFcnJvck1z
Z1tTUUxfTUFYX01FU1NBR0VfTEVOR1RIXTsNCg0KI2RlZmluZSBNQVhCVUZM
RU4gICAgMjU1DQojZGVmaW5lIFRBQl9MRU4gU1FMX01BWF9UQUJMRV9OQU1F
X0xFTiArIDENCiNkZWZpbmUgQ09MX0xFTiBTUUxfTUFYX0NPTFVNTl9OQU1F
X0xFTiArIDENCiNkZWZpbmUgU1RSX0xFTiAxMjgNCiNkZWZpbmUgUkVNX0xF
TiAyNTQrMQ0KI2RlZmluZSBCSUdfREFUQV9MRU4gMTAyNA0KU1FMQ0hBUiAg
ICAgICBTcWxTdGF0ZVs2XSwgTXNnW1NRTF9NQVhfTUVTU0FHRV9MRU5HVEhd
Ow0KU1FMSU5URUdFUiAgICBOYXRpdmVFcnJvcjsNClNRTFNNQUxMSU5UICAg
TXNnTGVuOw0KUkVUQ09ERSByZXRjb2RlOw0KDQpjaGFyICAgc3pEU05bMjBd
IDsNCmNoYXIgICBzelVJRFsyMF0gOw0KY2hhciAgIHN6QXV0aFN0clsyMF0g
Ow0KDQppbnQgY291bnQgPSAxMCwgbiAsIGk7DQppbnQgaUludGVydmFsOw0K
DQp2b2lkIGV4aXRfbmljZWx5KCl7DQoJaWYoIFJDX05PVFNVQ0NFU1NGVUwo
cmV0Y29kZSkgKQ0KCXsNCgkJU1FMR2V0RGlhZ1JlYyhTUUxfSEFORExFX1NU
TVQsIGhzdG10LCAxLCAoU1FMQ0hBUiopc3pTcWxTdGF0ZSwgJk5hdGl2ZUVy
cm9yLChTUUxDSEFSKilzekVycm9yTXNnLCBTUUxfTUFYX01FU1NBR0VfTEVO
R1RILCAmTXNnTGVuKTsNCgkJZnByaW50ZihzdGRvdXQsIlNxbFN0YXRlPSVz
LCBOYXRpdmVFcnJvcj0lZCwgRXJyb3JNc2c9JXNcbiIsIHN6U3FsU3RhdGUs
IE5hdGl2ZUVycm9yLCBzekVycm9yTXNnKTsNCgkJU1FMRXhlY0RpcmVjdCho
c3RtdCAsIChTUUxDSEFSKikiUk9MTEJBQ0siICwgU1FMX05UUyk7DQoJfQ0K
CS8vU1FMRXhlY0RpcmVjdChoc3RtdCAsIChTUUxDSEFSKikiUk9MTEJBQ0si
ICwgU1FMX05UUyk7DQoJU1FMRW5kVHJhbihTUUxfSEFORExFX0RCQywoU1FM
SERCQyloZGJjLCBTUUxfQ09NTUlUKTsNCgkvKiBDbGVhbiB1cC4gKi8NCiAg
ICBTUUxGcmVlU3RtdChoc3RtdCwgU1FMX0NMT1NFKTsNCglTUUxGcmVlSGFu
ZGxlKFNRTF9IQU5ETEVfU1RNVCwgaHN0bXQpOw0KCVNRTERpc2Nvbm5lY3Qo
aGRiYyk7DQoJU1FMRnJlZUhhbmRsZShTUUxfSEFORExFX0RCQywgaGRiYyk7
DQoJU1FMRnJlZUhhbmRsZShTUUxfSEFORExFX0VOViwgaGVudik7DQoJLy9n
ZXRjaGFyKCk7DQoJZXhpdCgxKTsNCn0NCg0Kdm9pZCBpbml0REJDb24oKXsN
Cg0KCS8vIEFsbG9jYXRlIHRoZSBPREJDIEVudmlyb25tZW50IGFuZCBzYXZl
IGhhbmRsZS4NCglyZXRjb2RlID0gU1FMQWxsb2NIYW5kbGUgKFNRTF9IQU5E
TEVfRU5WLCBOVUxMLCAmaGVudik7DQoNCgkvLyBMZXQgT0RCQyBrbm93IHRo
aXMgaXMgYW4gT0RCQyAzLjAgYXBwbGljYXRpb24uDQoJcmV0Y29kZSA9IFNR
TFNldEVudkF0dHIoaGVudiwgU1FMX0FUVFJfT0RCQ19WRVJTSU9OLA0KCQko
U1FMUE9JTlRFUilTUUxfT1ZfT0RCQzMsDQoJCVNRTF9JU19JTlRFR0VSKTsN
Cg0KCS8vIEFsbG9jYXRlIGFuIE9EQkMgY29ubmVjdGlvbiBoYW5kbGUgYW5k
IGNvbm5lY3QuDQoJcmV0Y29kZSA9IFNRTEFsbG9jSGFuZGxlKFNRTF9IQU5E
TEVfREJDLCBoZW52LCAmaGRiYyk7DQoNCgkvL1NldCBDb25uZWN0IEF0dHIN
CglyZXRjb2RlID0gU1FMU2V0Q29ubmVjdE9wdGlvbihoZGJjLFNRTF9BVVRP
Q09NTUlULCBTUUxfQVVUT0NPTU1JVF9PRkYpOw0KDQoJLy9Db25uZWN0DQoJ
cmV0Y29kZSA9IFNRTENvbm5lY3QoaGRiYywoU1FMQ0hBUiopc3pEU04sIChT
UUxTTUFMTElOVClzdHJsZW4oc3pEU04pLA0KCQkoU1FMQ0hBUiopc3pVSUQs
IChTUUxTTUFMTElOVClzdHJsZW4oc3pVSUQpLA0KCQkoU1FMQ0hBUiopc3pB
dXRoU3RyLCAoU1FMU01BTExJTlQpc3RybGVuKHN6QXV0aFN0cikpOw0KCWlm
KCBSQ19OT1RTVUNDRVNTRlVMKHJldGNvZGUpICkNCgl7DQoJCWV4aXRfbmlj
ZWx5KCk7DQoJfQ0KCS8vIEFsbG9jYXRlIHN0YXRlbWVudCBoYW5kbGVzIGFu
ZCBkbyBPREJDIHByb2Nlc3NpbmcuDQoJU1FMQWxsb2NIYW5kbGUoU1FMX0hB
TkRMRV9TVE1ULCBoZGJjLCAmaHN0bXQpOw0KCXJldHVybjsJDQp9DQp2b2lk
IGZyZWVEQkNvbigpew0KCVNRTEVuZFRyYW4oU1FMX0hBTkRMRV9EQkMsKFNR
TEhEQkMpaGRiYywgU1FMX0NPTU1JVCk7DQoJLyogQ2xlYW4gdXAuICovDQoJ
U1FMRnJlZVN0bXQoaHN0bXQsIFNRTF9DTE9TRSk7DQoJU1FMRnJlZUhhbmRs
ZShTUUxfSEFORExFX1NUTVQsIGhzdG10KTsNCglTUUxEaXNjb25uZWN0KGhk
YmMpOw0KCVNRTEZyZWVIYW5kbGUoU1FMX0hBTkRMRV9EQkMsIGhkYmMpOw0K
CVNRTEZyZWVIYW5kbGUoU1FMX0hBTkRMRV9FTlYsIGhlbnYpOw0KCXJldHVy
bjsNCn0NCg0Kdm9pZCB0ZXN0SW5zZXJ0KCkNCnsNCgljaGFyICpzcWxJbnNl
cnQ9Imluc2VydCBpbnRvIFRlc3RMZWFrIHZhbHVlcyg/LD8sPykiOw0KDQoJ
Y2hhciBzelRtcFsxMDFdOw0KCVNRTElOVEVHRVIgIHNPcmRlcklEPTAgLCBz
T3JkZXJJRDE9MCAsIGNiVmFsdWUyID0gU1FMX05UUzsJDQoJU1FMSU5URUdF
UiAgY2JPcmRlcklEID0gMCAsIGNiT3JkZXJJRDEgPSAwOw0KCS8vU1FMSU5U
RUdFUiAgY2JEYXRhOw0KCWludCBpOw0KDQoJLy9pbml0aWFsaXplIA0KCW1l
bXNldChzelRtcCwwLDEwMSk7DQoJbWVtc2V0KHN6VG1wLCdhJywxMCk7Ly9p
bnNlcnQgJ2EnDQoNCgkvL0lOU0VSVA0KCWZvcihpID0gMCA7IGkgPCBjb3Vu
dCA7IGkrKykNCgl7DQoJCXJldGNvZGUgPSBTUUxQcmVwYXJlKGhzdG10LAko
U1FMQ0hBUiopc3FsSW5zZXJ0LCBTUUxfTlRTKTsJCQ0KCQlTUUxCaW5kUGFy
YW1ldGVyKGhzdG10LCAxLCBTUUxfUEFSQU1fSU5QVVQsIFNRTF9DX1NMT05H
LCBTUUxfSU5URUdFUiwgMCwgMCwgJnNPcmRlcklELCAwLCAmY2JPcmRlcklE
KTsJCQ0KCQlTUUxCaW5kUGFyYW1ldGVyKGhzdG10LCAyLCBTUUxfUEFSQU1f
SU5QVVQsIFNRTF9DX0NIQVIsIFNRTF9DSEFSLFNUUl9MRU4sIDAsICZzelRt
cCwgMCwgJmNiVmFsdWUyKTsNCgkJU1FMQmluZFBhcmFtZXRlcihoc3RtdCwg
MywgU1FMX1BBUkFNX0lOUFVULCBTUUxfQ19TTE9ORywgU1FMX0lOVEVHRVIs
IDAsIDAsICZzT3JkZXJJRCwgMCwgJmNiT3JkZXJJRCk7CQkNCgkJc09yZGVy
SUQgPSBpOw0KCQlyZXRjb2RlID0gU1FMRXhlY3V0ZShoc3RtdCk7DQoJCWlm
KCBSQ19OT1RTVUNDRVNTRlVMKHJldGNvZGUpICkNCgkJew0KCQkJZXhpdF9u
aWNlbHkoKTsNCgkJfQ0KCX0NCgkvL3JldGNvZGUgPSBTUUxGcmVlU3RtdCho
c3RtdCxTUUxfUkVTRVRfUEFSQU1TKTsNCglTUUxFbmRUcmFuKFNRTF9IQU5E
TEVfREJDLChTUUxIREJDKWhkYmMsIFNRTF9DT01NSVQpOw0KfQ0KDQoNCnZv
aWQgdGVzdFVwZGF0ZSgpDQp7DQoJY2hhciAqc3FsVXBkYXRlPSJ1cGRhdGUg
VGVzdExlYWsgc2V0IGMyID0gPyB3aGVyZSBjMSA9ID8iOw0KCWNoYXIgc3pU
bXBbMTAxXTsNCglTUUxJTlRFR0VSICBzT3JkZXJJRD0wICwgc09yZGVySUQx
PTAgLCBjYlZhbHVlMiA9IFNRTF9OVFM7CQ0KCVNRTElOVEVHRVIgIGNiT3Jk
ZXJJRCA9IDAgLCBjYk9yZGVySUQxID0gMDsNCglpbnQgaTsNCgkNCg0KCS8v
aW5pdGlhbGl6ZSANCgltZW1zZXQoc3pUbXAsMCwxMDEpOw0KCW1lbXNldChz
elRtcCwnYicsMTApOy8vdXBkYXRlIHRvICdiJw0KDQoJLy9VcGRhdGUNCglm
b3IoaSA9IDAgOyBpIDwgY291bnQgOyBpKyspDQoJew0KCQlyZXRjb2RlID0g
U1FMUHJlcGFyZShoc3RtdCwJKFNRTENIQVIqKXNxbFVwZGF0ZSwgU1FMX05U
Uyk7CQkNCgkJU1FMQmluZFBhcmFtZXRlcihoc3RtdCwgMSwgU1FMX1BBUkFN
X0lOUFVULCBTUUxfQ19DSEFSLCBTUUxfQ0hBUixTVFJfTEVOLCAwLCAmc3pU
bXAsIDAsICZjYlZhbHVlMik7DQoJCVNRTEJpbmRQYXJhbWV0ZXIoaHN0bXQs
IDIsIFNRTF9QQVJBTV9JTlBVVCwgU1FMX0NfU0xPTkcsIFNRTF9JTlRFR0VS
LCAwLCAwLCAmc09yZGVySUQsIDAsICZjYk9yZGVySUQpOwkJDQoJCS8vU1FM
QmluZFBhcmFtZXRlcihoc3RtdCwgMywgU1FMX1BBUkFNX0lOUFVULCBTUUxf
Q19TTE9ORywgU1FMX0lOVEVHRVIsIDAsIDAsICZzT3JkZXJJRCwgMCwgJmNi
T3JkZXJJRCk7CQkNCgkJc09yZGVySUQgPSBpOyAJDQoJCXJldGNvZGUgPSBT
UUxFeGVjdXRlKGhzdG10KTsNCgkJaWYoIFJDX05PVFNVQ0NFU1NGVUwocmV0
Y29kZSkgKQ0KCQl7DQoJCQlleGl0X25pY2VseSgpOw0KCQl9DQoJfQ0KCVNR
TEVuZFRyYW4oU1FMX0hBTkRMRV9EQkMsKFNRTEhEQkMpaGRiYywgU1FMX0NP
TU1JVCk7DQp9DQoNCnZvaWQgdGVzdERlbGV0ZSgpDQp7DQoJY2hhciAqc3Fs
RGVsZXRlPSJERUxFVEUgZnJvbSBUZXN0TGVhayB3aGVyZSBjMSA9ID8iOw0K
CS8vY2hhciBzelRtcFsxMDFdOw0KCVNRTElOVEVHRVIgIHNPcmRlcklEPTAg
LCBzT3JkZXJJRDE9MDsJDQoJU1FMSU5URUdFUiAgY2JPcmRlcklEID0gMCAs
IGNiT3JkZXJJRDEgPSAwOw0KCWludCBpOw0KDQoJLy9EZWxldGUNCglmb3Io
aSA9IDAgOyBpIDwgY291bnQgOyBpKyspDQoJew0KCQlyZXRjb2RlID0gU1FM
UHJlcGFyZShoc3RtdCwJKFNRTENIQVIqKXNxbERlbGV0ZSwgU1FMX05UUyk7
CQkNCgkJU1FMQmluZFBhcmFtZXRlcihoc3RtdCwgMSwgU1FMX1BBUkFNX0lO
UFVULCBTUUxfQ19TTE9ORywgU1FMX0lOVEVHRVIsIDAsIDAsICZzT3JkZXJJ
RCwgMCwgJmNiT3JkZXJJRCk7CQkNCgkJc09yZGVySUQgPSBpOyAJCQ0KCQly
ZXRjb2RlID0gU1FMRXhlY3V0ZShoc3RtdCk7DQoJCWlmKCBSQ19OT1RTVUND
RVNTRlVMKHJldGNvZGUpICkNCgkJew0KCQkJZXhpdF9uaWNlbHkoKTsNCgkJ
fQ0KCX0NCglTUUxFbmRUcmFuKFNRTF9IQU5ETEVfREJDLChTUUxIREJDKWhk
YmMsIFNRTF9DT01NSVQpOw0KfQ0KDQppbnQgbWFpbihpbnQgYXJnYywgY2hh
ciAqYXJndltdICkgDQp7DQoNCglpbnQgbSA9IDE7DQoJaWYoIGFyZ2MgPT0g
MSApey8vZGVmYXVsdA0KCQlzcHJpbnRmKHN6RFNOLCJwb3N0Z3JlXzguMDJc
MCIpOw0KCQlzcHJpbnRmKHN6VUlELCJwb3N0Z3Jlc1wwIik7DQoJCXNwcmlu
dGYoc3pBdXRoU3RyLCJwb3N0Z3Jlc1wwIik7ICAgDQoJCWlJbnRlcnZhbCA9
IDE7DQoJfWVsc2UgaWYoIGFyZ2MgPT0gNSApew0KCQlzcHJpbnRmKHN6RFNO
LGFyZ3ZbMV0pOy8vRFNODQoJCXNwcmludGYoc3pVSUQsYXJndlsyXSk7Ly9V
c2VyDQoJCXNwcmludGYoc3pBdXRoU3RyLGFyZ3ZbM10pOy8vUGFzc3dvcmQg
ICANCgkJaUludGVydmFsID0gYXRvaShhcmd2WzRdKTsvL0ludGVydmFsDQoJ
fWVsc2V7DQoJCWZwcmludGYoc3Rkb3V0LCJpbnZhbGlkIGFyZ3MhXG4iKTsN
CgkJZnByaW50ZihzdGRvdXQsIlVzYWdlOiB0ZXN0T0RCQy5leGUgPERTTj4g
PFVzZXI+IDxQYXNzd29yZD4gPEludGVydmFsPiIpOw0KCQlyZXR1cm4oMCk7
DQoJfQ0KDQoJLy8tLS0tdGVzdCBiZWdpbi0tLS0tDQoJd2hpbGUodHJ1ZSl7
DQoJCWZwcmludGYoc3Rkb3V0LCJjb25uZWN0Li4uLlxuIik7DQoJCWluaXRE
QkNvbigpOw0KCQlmcHJpbnRmKHN0ZG91dCwiaW5zZXJ0Li4uLlxuIik7DQoJ
CXRlc3RJbnNlcnQoKTsNCgkJZnByaW50ZihzdGRvdXQsInVwZGF0ZS4uLi5c
biIpOw0KCQl0ZXN0VXBkYXRlKCk7DQoJCWZwcmludGYoc3Rkb3V0LCJkZWxl
dGUuLi4uXG4iKTsJDQoJCXRlc3REZWxldGUoKTsNCgkJU2xlZXAoMSoxMDAw
KTsNCgkJZnByaW50ZihzdGRvdXQsImZyZWUuLi4uXG4iKTsNCgkJZnJlZURC
Q29uKCk7DQoJfQ0KCS8vLS0tLXRlc3QgZW5kLS0tLS0NCglleGl0X25pY2Vs
eSgpOw0KfQ0KDQo=

--------------030607050502010804070508
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

--------------030607050502010804070508--

Re: Memory Leak ?

zhaoxin wrote:
> Toï¼=9A Hiroshi
>
>>
>> Well what do you mean by *Memory Leak* ?
>> Does the memory usage grow while repeating the loop ?
>>
> yes , in my test , I found memory usage keep growing .
>

How many bytes does it grow per the loop ?

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: Memory Leak ?

>>>
>>> Well what do you mean by *Memory Leak* ?
>>> Does the memory usage grow while repeating the loop ?
>>>
>> yes , in my test , I found memory usage keep growing .
>>
>
> How many bytes does it grow per the loop ?
>
I found it grows about 1k bytes per the loop.
In my test , the prgram loop about 30-40 times in one minute ,
and I founded 30-40K growth in one minute .
so , I think it leaks about 1k per the loop . is it right ?

regards,
zhao

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq