Re: [ADMIN] postgresql under Windows is slow

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: 30 January 2002 17:58
> To: Oleg Bartunov
> Cc: pgsql-admin(at)postgresql(dot)org; Pgsql Hackers
> Subject: Re: [HACKERS] [ADMIN] postgresql under Windows is slow
>
>
> Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> writes:
> > anybody has an experience how is stable postgresql under Windows
> > system ? I tried postgresq 7.1 under Cygwin, Windows 98 and was
> > dissapointed by very bad performance. Are there something I
> could tune
> > ? I got 250 sel/sec on simple select from table with 500
> rows ! Under
> > Linux I have 2500 sel/sec.
>
> Never tried it myself, but I distinctly recall someone
> reporting that they got comparable performance on Cygwin as
> on Linux. You might try asking on pgsql-cygwin.
>

I have never benchmarked it, but I do run pg on Cygwin/Win2K/XP and
Slackware Linux 8 on the same laptop. PostgreSQL always *seems* slower under
Cygwin.

However, I know that one of the guys at Greatbridge did do some benchmarking
and as I recall reported getting comparable performance up to about 100
users.

It's possible that it's because you are running on Windows 98. For the 7.2
release we've done all regression testing on XP/2K - I suspect that Jason
only tested 7.1 on NT4 or 2K.

Regards, Dave.