Thread: RE: [GENERAL] Memory leak in FreeBSD?

FreeBSD port: I don't know enough to know what difference that might make.
Any suggestion you have would be appreciated: thanks.

> -----Original Message-----
> From:    admin [SMTP:admin@wtbwts.com]
> Sent:    Tuesday, January 11, 2000 12:18 PM
> To:    Jeff Eckermann
> Cc:    'pgsql-general@postgresql.org'
> Subject:    Re: [GENERAL] Memory leak in FreeBSD?
>
> Did you upgrade from source or from the freebsd ports?
>
> > We upgraded to version 6.5.2 recently, running on FreeBSD 3.0.  Now we
> are
> > having problems with moderately complex queries failing to complete
> (backend
> > terminating unexpectedly; last one crashed the server).  The most likely
> > explanation appears to be a memory leak.  Is there any known problem
> with
> > FreeBSD?

What is maxusers set to in your kernel? One prolem I had was that
postgresql was using more filedescriptors that my kernel could handle. If
you'd like to check your current filedescriptor status and your max, try:
pstat -T. If that is your problem, change your maxusers to a suitable
number and recompile your kernel.

> FreeBSD port: I don't know enough to know what difference that might make.
> Any suggestion you have would be appreciated: thanks.
>
> > Did you upgrade from source or from the freebsd ports?
> >
> > > We upgraded to version 6.5.2 recently, running on FreeBSD 3.0.  Now we
> > are
> > > having problems with moderately complex queries failing to complete
> > (backend
> > > terminating unexpectedly; last one crashed the server).  The most likely
> > > explanation appears to be a memory leak.  Is there any known problem
> > with
> > > FreeBSD?
>