Re: Question about cygwin/Postgre

Nicolas,

I am currently running the Cygwin version of PostgreSQL in production and,
well, it works. My load is currently pretty light and the performance is
more than sufficient. I'm running on a PIII 500 w/ 512MB RAM and 3x9GB SCSI
in RAID 5.

From reading the Cygwin mailing list archives the only issue that you will
run into is the maximum number of concurrent connections which is a
limitation of the Cygwin libraries. I am having somewhere on the order of
100 simultaneous application users which results in only about 10 active
connections so I don't hit that limit. To find out the exact limits you will
want to search the mailing list archives.

Also, there is currently work under way to bring out a Win32 native version
of PostgreSQL. I *think* but am not certain that they are working to release
at the same time as 7.3. Last I saw they were asking for beta testers and
are, apparently, pretty close. Once again, search the mailing list archives
for more details.

My plans are to eventually move my database over to my 2xPIII 600 w/ 1GB RAM
and 3x18GB SCSI in RAID 5 running Linux but that won't happen until after I
get a new team member that understands (and can teach me) how to manage a
Linux server properly. Most likely in the January time frame. Until then I'm
hoping that either my load doesn't grow too terribly high or that the native
Win32 version comes out without the connection limitation.

rjsjr

> Nicolas Cartron wrote:
>
> All,
>
> Currently we're using a server that runs freebsd & postgreSQL.
>
> I've got to install a win 2k server, and i'd like to stay with
> postgre rather than install sql server.
>
> I didn't find any postgre win32 version, and am wondering if
> cygwin/postgre on such a server would be good (i mean in terms
> of performance of course).
>
> The server is an athlon 1.4 GHz with 1 Go RAM and 2 x 80 Go
> maxtor ide, so rather powerful.
>
> Thanks in advance.