Skip site navigation (1)Skip section navigation (2)
Date:      Tue, 15 Mar 2005 12:34:47 +0100
From:      Roman Neuhauser <neuhauser@chello.cz>
To:        Scott Long <scottl@samsco.org>
Cc:        freebsd-amd64@freebsd.org
Subject:   Re: amr performance woes and a bright side
Message-ID:  <20050315113447.GD10877@isis.sigpipe.cz>
In-Reply-To: <42366B99.4040904@samsco.org>
References:  <1110847561.3412.38.camel@lanshark.dmv.com> <42366B99.4040904@samsco.org>

next in thread | previous in thread | raw e-mail | index | archive | help
# 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



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20050315113447.GD10877>