memory problems with freebsd

From: matthieuclavier(at)mageos(dot)com
To: PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: memory problems with freebsd
Date: 2001-07-26 14:51:13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general


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:

options SHMALL=32768
options SEMUME=40
options SHMMAXPGS=32768
options SHMSEG=256
options SEMMNI=256
options SEMMNS=512
options SEMMNU=256
options SEMMAP=256

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
Alfred Perlstein.
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
problem ?
the REAME.v7.1 talk about bug fixes on memory leak problem.

any experience, and/or advisory will be appreciated.

Matthieu Clavier

Browse pgsql-general by date

  From Date Subject
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