Windows native version of PostgreSQL.

From: mlw <markw(at)mohawksoft(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Windows native version of PostgreSQL.
Date: 2001-10-05 12:33:13
Message-ID: 3BBDA889.AEC44C8B@mohawksoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I just finished up some work bringing a Linux/FreeBSD server project to
Windows. Enough to test at least. (I have to find a version of getopt() for
Windows) What I found was surprising.

My server project is like a database cache for Web servers. It is used to keep
session information across page views without getting database hits for each
page. One of the reasons why I wrote it was PostgreSQL's behavior with updates.

At first I tried to use Cygwin, and it was really easy, but it was very slow.
Then I decided that I had to write the actual Windows bits myself. (I
programmed Windows and NT for over a decade, so I remember how)

The difference was astounding!!! On the machine running Windows, sitting on a
switch, The cygwin version could get roughly 50 session dialogs a second, the
native Windows version was able to get roughly 250. I am sure that this is
mostly due to the implementation of pthread_mutex and sockets, because I make
very few other system calls.

The question which pops in to mind, has anyone run the PostgreSQL that comes
with cygwin and compared it on the same machine running Linux or FreeBSD? Is
the performance comparable?

If not, does anyone know if that is due to the inefficiencies between *NIX and
Windows? Or is Cygwin generally slow all around?

Does anyone care enough about Windows to attempt a "native Windows" port? I
would be able to contribute some time. (couple hours a day, a few days a week)

Browse pgsql-hackers by date

  From Date Subject
Next Message Fábio Santana 2001-10-05 13:08:32 I NEED HELP
Previous Message Marc G. Fournier 2001-10-05 12:24:11 Re: cvs problem