From: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> |
---|---|
To: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
Cc: | <pgsql-performance(at)postgresql(dot)org>, "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Subject: | Re: [pgsql-hackers-win32] scalability issues on win32 |
Date: | 2004-11-23 17:06:47 |
Message-ID: | 6EE64EF3AB31D5448D0007DD34EEB3412A7535@Herge.rcsinc.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
> 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 agree with Magnus. Specifically, I suspect there is some sort of
resource contention going on that is driving up the cpu load when the
queries follow certain patterns. This resource contention could be
happening in the win32 port code (likely ipc), the mingw api, or inside
the o/s itself.
Other servers, namely apache, sql server and a host of others do not
have this problem.
Merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Cott Lang | 2004-11-23 17:20:07 | Re: Some quick Opteron 32-bit/64-bit results |
Previous Message | Pierre-Frédéric Caillaud | 2004-11-23 16:45:27 | Re: Data type to use for primary key |