Re: [HACKERS] postgresql under Windows is slow

On Wed, 30 Jan 2002, Dave Page wrote:

>
>
> > -----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.

Who is this guy ? What I can do to get more preformance ?
Is't possible to compile 7.2 sources under Cygwin ? Do I need to do
something special ?

>
> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83