pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedSTRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG
6+ messages / 4 participants
[nested] [flat]
* STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG
@ 2001-01-24 16:25 Maurizio <maurizio@dreamtech-it.com>
2001-01-26 07:09 ` Re: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG Michael Meskes <meskes@postgresql.org>
0 siblings, 1 reply; 6+ messages in thread
From: Maurizio @ 2001-01-24 16:25 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG
2001-01-24 16:25 STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG Maurizio <maurizio@dreamtech-it.com>
@ 2001-01-26 07:09 ` Michael Meskes <meskes@postgresql.org>
0 siblings, 0 replies; 6+ messages in thread
From: Michael Meskes @ 2001-01-26 07:09 UTC (permalink / raw)
To: Maurizio <maurizio@dreamtech-it.com>; +Cc: pgsql-interfaces
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!
^ permalink raw reply [nested|flat] 6+ messages in thread
* Fw: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG
@ 2001-01-25 07:00 Maurizio <maurizio.c@libero.it>
2001-01-26 21:35 ` Re: Fw: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: Maurizio @ 2001-01-25 07:00 UTC (permalink / raw)
To: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Fw: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG
2001-01-25 07:00 Fw: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG Maurizio <maurizio.c@libero.it>
@ 2001-01-26 21:35 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-01-27 07:03 ` Re: Fw: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG Maurizio <maurizio.c@libero.it>
2001-01-27 13:52 ` Re: Fw: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG Maurizio <maurizio.c@libero.it>
0 siblings, 2 replies; 6+ messages in thread
From: Bruce Momjian @ 2001-01-26 21:35 UTC (permalink / raw)
To: Maurizio <maurizio.c@libero.it>; +Cc: pgsql-interfaces
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Fw: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG
2001-01-25 07:00 Fw: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG Maurizio <maurizio.c@libero.it>
2001-01-26 21:35 ` Re: Fw: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG Bruce Momjian <pgman@candle.pha.pa.us>
@ 2001-01-27 07:03 ` Maurizio <maurizio.c@libero.it>
1 sibling, 0 replies; 6+ messages in thread
From: Maurizio @ 2001-01-27 07:03 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: pgsql-interfaces; Michael Meskes <meskes@postgresql.org>
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Fw: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG
2001-01-25 07:00 Fw: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG Maurizio <maurizio.c@libero.it>
2001-01-26 21:35 ` Re: Fw: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG Bruce Momjian <pgman@candle.pha.pa.us>
@ 2001-01-27 13:52 ` Maurizio <maurizio.c@libero.it>
1 sibling, 0 replies; 6+ messages in thread
From: Maurizio @ 2001-01-27 13:52 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: pgsql-interfaces
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
Attachments:
Make.log (application/octet-stream, 91.4K) download
Install.log (application/octet-stream, 18.0K) download
Init.log (application/octet-stream, 546B) download
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2001-01-27 13:52 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-24 16:25 STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG Maurizio <maurizio@dreamtech-it.com>
2001-01-26 07:09 ` Michael Meskes <meskes@postgresql.org>
2001-01-25 07:00 Fw: STRANGE INCREMENT IN MEMORY SIZE OF A PRECESS COMPILED WITH ECPG Maurizio <maurizio.c@libero.it>
2001-01-26 21:35 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-01-27 07:03 ` Maurizio <maurizio.c@libero.it>
2001-01-27 13:52 ` Maurizio <maurizio.c@libero.it>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox