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
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 |
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 |