From: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> |
---|---|
To: | "Reini Urban" <rurban(at)x-ray(dot)at> |
Cc: | <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 13:05:27 |
Message-ID: | 6EE64EF3AB31D5448D0007DD34EEB3412A7533@Herge.rcsinc.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers-win32 pgsql-performance |
Reini Urban wrote:
> Merlin Moncure schrieb:
> > A good benchmark of our application performance is the time it takes
to
> > read the entire bill of materials for a product. This is a
recursive
> > read of about 2500 records in the typical case (2408 in the test
case).
>
> I always knew that COBOL ultimativly looses, but it's always
refreshing
> to get confirmation from time to time :)
Heh. It's important to make the distinction between COBOL, which is
just a language, and ISAM, which is a data delivery system. You could,
for example, pair COBOL with SQL with good results, (in fact, we plan
to). But yes, many legacy COBOL apps were written with assumptions
about the system architecture that are no longer valid.
> Where did you get the win32 "avg cpu load" number from? AFAIK there's
no
> getloadavg() for windows. At least I tried hard to find one, because I
> want to add a comparable figure to cygwin core. emacs, coreutils, make
> and others would need desperately need it, not to speak of servers and
> real-time apps.
I just eyeballed it :-). So consider the load averages anecdotal,
although they are quite stable. However it is quite striking that with
the same application code the win32 load average was 2-3 times higher.
I also left out the dual processor results, because I did not have time
to test them on linux. However, sadly the 2nd processor adds very
little extras horsepower to the server. I'm hoping linux will be
better.
Merlin
From | Date | Subject | |
---|---|---|---|
Next Message | Merlin Moncure | 2004-11-23 13:13:13 | Re: scalability issues on win32 |
Previous Message | Dave Page | 2004-11-23 10:35:54 | Re: scalability issues on win32 |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Darley | 2004-11-23 14:59:42 | Re: Data type to use for primary key |
Previous Message | Dave Page | 2004-11-23 10:35:54 | Re: scalability issues on win32 |