From: Mark Kirkwood <markir@paradise.net.nz>
To: Darcy Buskermolen <darcy@wavefire.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait!
Date: Wed, 24 Mar 2004 21:26:27 +1200
Message-ID: <40615443.4030003@paradise.net.nz> (raw)
In-Reply-To: <200403231248.34425.darcy@wavefire.com>
References: <200403231248.34425.darcy@wavefire.com>
Darcy Buskermolen wrote:
>---------- Forwarded Message ----------
>
>Subject: FreeBSD, PostgreSQL, semwait and sbwait!
>Date: March 23, 2004 12:02 pm
>From: "Jason Coene" <jcoene@gotfrag.com>
>To: <freebsd-performance@freebsd.org>
>
>Hello all,
>
>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
>
>
Could this be a 5.2 performance issue ?
In spite of certain areas where the 5.x series performance is known to
be much better than 4.x (e.g networking), this may not be manifested in
practice for a complete application.
(e.g. I am still running 4.9 as it outperformed 5.1 vastly for a ~100
database sessions running queries - note that I have not tried out 5.2,
so am happy to be corrected on this)
regards
Mark
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: markir@paradise.net.nz, darcy@wavefire.com
Subject: Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait!
In-Reply-To: <40615443.4030003@paradise.net.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox