Re: PostgreSQL vs Firebird feature comparison finished

Alban Hertroys wrote:
> Joshua D. Drake wrote:
>>> I agree with you on the multi-threaded. I think I will add a note
>>> saying the the multi-threaded architecture is only advantageous on
>>> Windows.
>> And Solaris.
>
> I'm not entirely sure what makes multi-threading be advantageous on a
> specific operating system, but I think FreeBSD should be added to that
> list as well... They've been bench marking their threading support using
> multi-threading in MySQL (not for the db, mind you - just for load ;),
> and it performs really well.
>

I'm not sure I necessarily agree with those two - we have no real proof
that a multithreaded architecture would be significantly more efficient
than a multi process. It certainly wouldn't be as robust as an error in
one backend thread could bring down the entire server.

Windows is a special case in this regard. The OS has been designed from
the outset as a threaded environment. The important point is not that
Windows threads are necessarily any more efficient than their Solaris or
FreeBSD counterparts, but that the multi-process architecture is alien
to Windows and is inherently slower. Two of the major bottlenecks we
have on Windows as a result are backend startup time and shared memory
access speed - both of which are significantly slower than on *nix.

Regards, Dave