From owner-freebsd-amd64@FreeBSD.ORG  Tue Mar 15 11:34:49 2005
Return-Path: <owner-freebsd-amd64@FreeBSD.ORG>
Delivered-To: freebsd-amd64@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 74C5116A4CE
	for <freebsd-amd64@freebsd.org>; Tue, 15 Mar 2005 11:34:49 +0000 (GMT)
Received: from isis.sigpipe.cz (r2g224.chello.upc.cz [62.245.70.224])
	by mx1.FreeBSD.org (Postfix) with ESMTP id C797B43D5C
	for <freebsd-amd64@freebsd.org>; Tue, 15 Mar 2005 11:34:48 +0000 (GMT)
	(envelope-from neuhauser@chello.cz)
Received: by isis.sigpipe.cz (Postfix, from userid 1001)
	id E33C61F87BEE; Tue, 15 Mar 2005 12:34:47 +0100 (CET)
Date: Tue, 15 Mar 2005 12:34:47 +0100
From: Roman Neuhauser <neuhauser@chello.cz>
To: Scott Long <scottl@samsco.org>
Message-ID: <20050315113447.GD10877@isis.sigpipe.cz>
References: <1110847561.3412.38.camel@lanshark.dmv.com>
	<42366B99.4040904@samsco.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <42366B99.4040904@samsco.org>
User-Agent: Mutt/1.5.6i
cc: freebsd-amd64@freebsd.org
Subject: Re: amr performance woes and a bright side
X-BeenThere: freebsd-amd64@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Porting FreeBSD to the AMD64 platform <freebsd-amd64.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-amd64>,
	<mailto:freebsd-amd64-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-amd64>
List-Post: <mailto:freebsd-amd64@freebsd.org>
List-Help: <mailto:freebsd-amd64-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-amd64>,
	<mailto:freebsd-amd64-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 15 Mar 2005 11:34:49 -0000

# scottl@samsco.org / 2005-03-14 21:59:05 -0700:
> So setting aside the bonnie tests, the PQSQL stats do indeed show a 
> problem.  Is PGSQL threaded?  If so, you might be running into some of
> the threading performance problems that are well known and are being 
> worked on.  I don't know a whole lot about PGSQL or the tests that you 
> are talking about, but if you had an easy recipe for duplicating your 
> test environment, I'd like to experiment some myself.

    PostgreSQL is a forked program, it forks a backend process for each
    connection, using shared memory for communication between the
    backends.

-- 
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991