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

Re: Committing Resources to Win32

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: Committing Resources to Win32
Date: 2003-11-10 22:57:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers-win32
> *nod*
> Joshua, can you tell us any more about the nature of your client's 
> app(s)? Speculating like this in the dark is a bit fruitless.
I can't legally tell you much but what I can tell you is:

There application creates a great deal of processes that open and close. 

On Linux which has a very light process model the performance hit is 
nominal. On platforms like Win32 or Solaris where processes are 
expensive, under heavy load you can see a pretty significant increase in 
performance by going to a threaded model.

They are currently running our Cygwin installation which combined with 
connection pooling has provided "ok" performance but nothing
worth writing home about (especially considering they compared against 

I am not going to lie, from a Windows perspective I am a little bit of a 
PHB. I don't develop (personally) on Windows. However the
customer requirements are simple:

Command Prompt needs to provide a native Win32 PostgreSQL version that 
supplies a reasonable proximity of performance
per the Linux native version. The Win32 native version must also 
maintain the same level of transactibility as the Linux version.

My customer is a house of Windows C/C++ and they are telling me that 
using CreateProcess will not generate that proximity.

They and I could be totally on crack, but my own research suggests 
pretty much the same thing and the Windows programmers
that I have talked to that are not associated with this customer also 
say the same thing.

What this all comes down to for us is this:

Can we (the community) develop a Win32 native version using 
CreateProcess that will scale and perform at a level that
is acceptable to wide general use. Understanding that for many 
operations PostgreSQL on Linux will perform as well if
not faster than the other well known database with the letter O in their 


Joshua Drake

> cheers
> andrew
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?

Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - jd(at)commandprompt(dot)com -
Editor-N-Chief - PostgreSQl.Org -

In response to


pgsql-hackers-win32 by date

Next:From: Joshua D. DrakeDate: 2003-11-10 22:58:11
Subject: Re: Committing Resources to Win32
Previous:From: Marsh RayDate: 2003-11-10 22:45:13
Subject: Re: Committing Resources to Win32

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