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

Re: scalability issues on win32

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

pgsql-performance by date

Next:From: Peter DarleyDate: 2004-11-23 14:59:42
Subject: Re: Data type to use for primary key
Previous:From: Dave PageDate: 2004-11-23 10:35:54
Subject: Re: scalability issues on win32

pgsql-hackers-win32 by date

Next:From: Merlin MoncureDate: 2004-11-23 13:13:13
Subject: Re: scalability issues on win32
Previous:From: Dave PageDate: 2004-11-23 10:35:54
Subject: Re: scalability issues on win32

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