Re: Linux v.s. Mac OS-X Performance

Trevor Talbot <quension@gmail.com>

From: "Trevor Talbot" <quension@gmail.com>
To: "Joshua D. Drake" <jd@commandprompt.com>
Cc: "Magnus Hagander" <magnus@hagander.net>, "Scott Ribe" <scott_ribe@killerbytes.com>, "pgsql general" <pgsql-general@postgresql.org>
Date: 2007-11-28T18:44:07Z
Lists: pgsql-general
On 11/28/07, Joshua D. Drake <jd@commandprompt.com> wrote:

> On Wed, 28 Nov 2007 09:53:34 -0800
> "Trevor Talbot" <quension@gmail.com> wrote:

> > > On Wed, 2007-11-28 at 07:29 -0700, Scott Ribe wrote:
> > > > > Yes, very much so. Windows lacks the fork() concept, which is
> > > > > what makes PostgreSQL much slower there.

> > I mean, I can understand NT having bottlenecks in various areas
> > compared to Unix, but this "threads are specially optimized" thing is
> > seeming a bit overblown.  Just how often do you see threads from a
> > single process get contiguous access to the CPU?

> I thought it was more about the cost to fork() a process in win32?

Creating a process is indeed expensive on Windows, but a followup
question was about the performance when using persistent connections,
and therefore not creating processes. That's where the conversation
got more interesting :)