FreeBSD upgrade causes performance degredation

From: "Peter Schmidt" <peterjs(at)home(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: FreeBSD upgrade causes performance degredation
Date: 2001-10-29 15:46:45
Message-ID: 9rjti6$if8$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message George Eric R Contr AFSPC/CVYZ 2001-10-29 16:29:59 Re: Ultimate DB Server
Previous Message Craig Jarman 2001-10-29 12:27:22 Error: Relation 'testdb' does not exist