|To:||PostgreSQL general <pgsql-general(at)postgresql(dot)org>|
|Subject:||memory problems with freebsd|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
we work with PostgreSQL 7.0.3 and FreeBSD (4.2 / 4.3).
the database is in production state, and daily heavy loaded.
i think our problems are similar to problems
described in :
recently, we have updated our kernel, according to this doc :
here the options we have tuned:
everything looks working fine, but after 9 or 10 days
in production, some problems appeared :
sometimes each postmaster child stay in a strange state,
according to top, 'semwait' state.
running ipcclean clean all those children !
sometimes, when the number of postmaster raise up to the limit,
we can't connect to the backend, we've got the message :
"psql: The Data Base System is in recovery mode"
after a pg_ctl stop, the message changes into :
"psql: The Data Base System is shutting down"
but the database never shutdown ( or are we too impatient ?).
it appeared that the inactive memory raise, until
we'v got 10 megs of free memory, as described by
after a reboot, everything looks fine but after 10 days of uptime,
the problem is the same.
we have just updated our FreeBSD kernel to 4.3.
is this update pertinent ?
are the selected values for the kernel options
speed up a memory leak problem ?
(the problems appeared faster since our kernel optimisation)
can an update of postgresql from 7.0.3 to 7.1.2 solve this
the REAME.v7.1 talk about bug fixes on memory leak problem.
any experience, and/or advisory will be appreciated.
|Next Message||Justin Clift||2001-07-26 15:03:31||Re: Hardware Recommendations|
|Previous Message||Bruno Wolff III||2001-07-26 12:36:20||Re: Good random numbers in PG? And crypto-wishlist|