Received: from smtp3.libero.it (smtp3.libero.it [193.70.192.53])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0R70Oq17762;
	Sat, 27 Jan 2001 02:00:24 -0500 (EST)
	(envelope-from maurizio.c@libero.it)
Received: from maurizio (151.29.213.239) by smtp3.libero.it (5.5.015.5)
	id 3A546BEB00EB6DB5; Sat, 27 Jan 2001 07:59:50 +0100
Message-ID: <002101c0882f$3b2206a0$7394fea9@maurizio>
From: "Maurizio" <maurizio.c@libero.it>
To: "Bruce Momjian" <pgman@candle.pha.pa.us>
Cc: <pgsql-interfaces@postgresql.org>,
 "Michael Meskes" <meskes@postgresql.org>
References: <200101262135.QAA09149@candle.pha.pa.us>
Subject: Re: Fw: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH
	ECPG
Date: Sat, 27 Jan 2001 08:03:18 +0100
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
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/307
X-Sequence-Number: 933

I will try today. Then I will send the risults.


Thanks
Maurizio

.
----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "Maurizio" <maurizio.c@libero.it>
Cc: <pgsql-interfaces@postgresql.org>
Sent: Friday, January 26, 2001 10:35 PM
Subject: Re: [INTERFACES] Fw: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS
COMPILED WITH ECPG


>
> Can you try 7.1 beta and see if that fixes it?
>
> [ Charset ISO-8859-1 unsupported, converting... ]
> >
> > 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 != 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 and 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
>
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026