Maxusers is set to 128. RAM is 256Mg.
Do you think this could be the problem?
> -----Original Message-----
> From: admin [SMTP:admin@wtbwts.com]
> Sent: Tuesday, January 11, 2000 12:50 PM
> To: Jeff Eckermann
> Cc: 'pgsql-general@postgresql.org'
> Subject: RE: [GENERAL] Memory leak in 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?
> >
>
>
> ************