Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackers-win32pgsql-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

pgsql-performance by date

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

pgsql-hackers-win32 by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group