Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0PI6Oq80124 for ; Thu, 25 Jan 2001 13:06:24 -0500 (EST) (envelope-from pgsql-interfaces-owner@postgresql.org) Received: from ns.tldnamesitalia.com (ns.tldnamesitalia.com [66.33.0.11]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0OGOEq27568 for ; Wed, 24 Jan 2001 11:24:14 -0500 (EST) (envelope-from maurizio@dreamtech-it.com) Received: from maurizio (ppp-94-215.29-151.libero.it [151.29.215.94]) by ns.tldnamesitalia.com (8.9.3/8.9.3) with SMTP id RAA14215 for ; Wed, 24 Jan 2001 17:17:29 +0100 Message-ID: <001801c08622$700ec4c0$7394fea9@maurizio> From: "Maurizio" To: Subject: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG Date: Wed, 24 Jan 2001 17:25:42 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0015_01C0862A.AD637A20" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200101/294 X-Sequence-Number: 918 Messaggio in formato MIME composto da pił parti. ------=_NextPart_000_0015_01C0862A.AD637A20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I have noted a strange increment in memory use on the system and I compiled= a little test program to check it. exec sql connect DB; exec sql declare CUR fror select ............ while(1) { exec sql open CUR; while(sqlca.sqlcode !=3D 100) exec sql fetch from CUR into :V1, V2; exec sql close CUR; delay(1); } exec sql disconnect DB; Every 7 - 10 seconds the size of this proces increase by 8K. I use QNX operating system and I noted this problem with POSTGRESQL 7.0.2 a= nd 7.0.3. Could someone help me, please ?? Thanks Maurizio Maurizio Cauci DREAMTECH di Cauci Maurizio Via Ronchetti, 2 - 21013 Gallarate (VA) www.dreamtech-it.com ------=_NextPart_000_0015_01C0862A.AD637A20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,
 
I have noted a strange increment in memory= use on=20 the system and I compiled a little test program to check it.
 
exec sql connect DB;
exec sql declare CUR fror select=20 ............
while(1)
{
    exec sql open CUR;
    while(sqlca.sqlcode != =3D=20 100)
        exec= sql=20 fetch from CUR into :V1, V2;
    exec sql close CUR;
 
    delay(1);
}
exec sql disconnect DB;
 
Every 7 - 10 seconds the si= ze of=20 this proces increase by 8K.
 
I use QNX operating system and I noted thi= s problem=20 with POSTGRESQL 7.0.2 and 7.0.3.
 
Could someone help me, please ??
 
 
Thanks
 
Maurizio
 
 
Maurizio Cauci
DREAMTECH di Cauci=20 Maurizio
Via Ronchetti, 2 - 21013 Gallarate (VA)
www.dreamtech-it.com
<= /BODY> ------=_NextPart_000_0015_01C0862A.AD637A20--