Postgres Pro
Downloads
Home   >   mailing lists

Thread: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG

STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG

From
"Maurizio"
Date:
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

Re: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG

From
Michael Meskes
Date:
On Wed, Jan 24, 2001 at 05:25:42PM +0100, Maurizio wrote:
> I have noted a strange increment in memory use on the system and I
> compiled a little test program to check it.
> ...

> I use QNX operating system and I noted this problem with POSTGRESQL 7.0.2
> and 7.0.3.

Is there any chance you could try this again with the latest CVS snapshot? I
know Bruce fixed some memory holes. 

There was another report of a memory leak some time ago, but until now I
haven't been able to reproduce either of these.

Michael
-- 
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!