Date: Tue, 23 Mar 2004 21:49:27 +0100 (CET) From: =?iso-8859-1?q?Claus=20Guttesen?= <cguttesen@yahoo.dk> To: Jason Coene <jcoene@gotfrag.com>, freebsd-performance@freebsd.org Subject: Re: FreeBSD, PostgreSQL, semwait and sbwait! Message-ID: <20040323204927.35614.qmail@web14102.mail.yahoo.com> In-Reply-To: <200403232002.i2NK2Gam077177@mail.gotfrag.com>
next in thread | previous in thread | raw e-mail | index | archive | help
> We're having a substantial problem with our FreeBSD > 5.2 database server > running PostgreSQL - it's getting a lot of traffic > (figure about 3,000 > queries per second), but queries are slow, and it's > seemingly waiting on > other things than CPU time. > ... > It seems that queries are executing fine once they > start, but it's taking a > while for them to get going, while the postgres It may not apply, but is DNS configured correct? Try connect with ssh and see if it takes a few sec's before you connect. Your postgres-info seems fine. As a sidenote you may want to copy GENERIC to a new file and compile that one instead. During your next cvsup GENERIC will be recovered to it's original state and your changes will be lost. regards Claus Yahoo! Mail (http://dk.mail.yahoo.com) - Gratis: 6 MB lagerplads, spamfilter og virusscan
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20040323204927.35614.qmail>