FreeBSD 4.1 vs FreeBSD 4.4 on X86
Postrgesql 7.03
We are experiencing a siginficant drop in performance in some PostgreSQL
database operations after upgrading FreeBSD 4.1 to FreeBSD 4.4. Database
connections appear to be twice as slow while calling some of our own
functions can take 10x longer. Does anyone have any ideas why this is
occurring?
kernel options added for postgres present in both versions of FreeBSD (gives
us ~100 connections)
SEMMNI=22 # number of semaphore identifiers
SEMMNS=122 # number of semaphores in system
SEMUME=22 # max number of undo entries per process
SEMMNU=62 # number of undo structures in system
Thanks for any and all comments.
Peter Schmidt
peterjs(at)home(dot)com