Well, one of the leaks that Purify detected was that individual lines read
from files were malloc'ed but not freed properly. So, if a line is
malloc'ed to about 8K (and we are reading thousands of lines in COPY reg
test I believe) and is not freed before next line is read, we get
significant memory usage... Plus adding all other leaks we get into major
problems...
I fixed the 'lines' leak so we shall see what happens...The backend should
be interesting...
=+=------------------------/\---------------------------------=+=
Igor Natanzon |**| E-mail: igor@sba.miami.edu
=+=------------------------\/---------------------------------=+=
On Mon, 2 Jun 1997, Bruce Momjian wrote:
> >
> > Oh the pressure :)...Anyways, PSQL has a huge leak (90% reported by
> > Purify, whatever that means :) ) in reading in external sql files (through
> > -f option)...this might be contributing to recent reports of memory leaks
> > during regression tests (aside from the backend which is another issue)...
> >
> > I am working on it right now, but I don't think PSQL issue is important
> > enough to delay the release....if everything checks out allright by Friday
> > then we should release it...Then starting with 6.2 make sure we eliminate
> > as many memory problems as possible....
> >
> > Oh well, just a thought....
> >
> > BTW...I will be out of town next week, then when I come back it's Jury
> > duty...so I'll try to finish psql/libpq by this week anyway....
>
> OK, let's see where we are at the end of the week. Take it as far as
> you can. I am curious what you see in the backend.
>
> People are reporting more memory problems than in 6.1. It may be psql,
> or libpq, or it may be a few things that we added to the backend that
> are causing problems.
>
> When people are running the regression tests multiple times and seeing
> errors, how are you doing that? Doesn't the backend and psql restart on
> every iteration? Is it the postmaster that is growing too big?
>
> --
> Bruce Momjian
> maillist@candle.pha.pa.us
>
------------------------------