Postgres Pro
Downloads
Home   >   mailing lists

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

Fw: 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: Fw: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG

From
Bruce Momjian
Date:
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,
Pennsylvania19026

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

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

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

From
"Maurizio"
Date:
I have some problem compiling 7.1 beta3.
I had included fmgr.h in dynloder.h because I had some errors.
Now there are some warnings about semaphores (sem_init, sem_trywai and
sem_post).
Attached are make.log, install.log and what happen when I run initdb
(init.log).


.
----- 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