amr performance woes and a bright side

Roman Neuhauser neuhauser at chello.cz
Tue Mar 15 03:34:49 PST 2005


# scottl at 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


More information about the freebsd-amd64 mailing list