Skip site navigation (1) Skip section navigation (2)

Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait!

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: Darcy Buskermolen <darcy(at)wavefire(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait!
Date: 2004-03-24 09:26:27
Message-ID: 40615443.4030003@paradise.net.nz (view raw or flat)
Thread:
Lists: pgsql-performance
Darcy Buskermolen wrote:

>----------  Forwarded Message  ----------
>
>Subject: FreeBSD, PostgreSQL, semwait and sbwait!
>Date: March 23, 2004 12:02 pm
>From: "Jason Coene" <jcoene(at)gotfrag(dot)com>
>To: <freebsd-performance(at)freebsd(dot)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


In response to

Responses

pgsql-performance by date

Next:From: pginfoDate: 2004-03-24 10:20:15
Subject: slow vacuum performance
Previous:From: Mark KirkwoodDate: 2004-03-24 09:09:02
Subject: Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group