Re: scalability issues on win32

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
Cc: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>, <pgsql-performance(at)postgresql(dot)org>, "PostgreSQL Win32 port list" <pgsql-hackers-win32(at)postgresql(dot)org>
Subject: Re: scalability issues on win32
Date: 2004-11-23 16:25:50
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE4761F6@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32 pgsql-performance

> > > This was an intersting Win32/linux comparison. I expected
> Linux to
> > > scale better, but I was surprised how poorly XP scaled. It
> > > reinforces our perception that Win32 is for low traffic servers.
> >
> > That's a bit harsh given the lack of any further
> investigation so far
> > isn't it? Win32 can run perfectly well with other DBMSs
> with hundreds
> > of users.
>
> The general opinion of server users is that you need 2-4 more
> Win32 servers to do the same work as one Unix-like server.
> That and the difficulty of automated administration and
> security problems is what is preventing Win32 from making
> greater inroads into the server marketplace.
>
> Of course these are just generalizations.

Is this for Postgresql Cygwin? You surely can't mean "for all server
tasks" - if so, I would say that's *way* off. There is a difference, but
it's more along the line of single-digit percentage in my experience -
provided you config your machines reasonably, of course.

(In my experience, Win32 MSSQLServer often outperforms postgresql on
Linux. Granted you can tweak postgresql up to higher speeds, but MS does
most of that tweaking automatically... Talking of tweaking a lot more
specific than just raising the memory limits from the installation
default, of course)

I do agree on the automated administration though... It's a major PITA.

//Magnus

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Vitaly Belman 2004-11-23 18:41:50 tsearch2 under Win32 in beta4?
Previous Message Bruce Momjian 2004-11-23 15:06:17 Re: scalability issues on win32

Browse pgsql-performance by date

  From Date Subject
Next Message Alexandre Leclerc 2004-11-23 16:29:45 Re: Data type to use for primary key
Previous Message Bruce Momjian 2004-11-23 15:06:17 Re: scalability issues on win32