Received: from smtp2.libero.it (smtp2.libero.it [193.70.192.52]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0P6vBq15435 for ; Thu, 25 Jan 2001 01:57:11 -0500 (EST) (envelope-from maurizio.c@libero.it) Received: from maurizio (151.29.214.155) by smtp2.libero.it (5.5.015.5) id 3A5365A600E228C6 for pgsql-interfaces@postgresql.org; Thu, 25 Jan 2001 07:57:09 +0100 Message-ID: <001e01c0869c$86d68600$7394fea9@maurizio> From: "Maurizio" To: Subject: Fw: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG Date: Thu, 25 Jan 2001 08:00:38 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001B_01C086A4.E7E24C60" 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/289 X-Sequence-Number: 913 Messaggio in formato MIME composto da pił parti. ------=_NextPart_000_001B_01C086A4.E7E24C60 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_001B_01C086A4.E7E24C60 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_001B_01C086A4.E7E24C60--