Thread: Re: [ADMIN] postgresql under Windows is slow

Re: [ADMIN] postgresql under Windows is slow

From
Dave Page
Date:

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us] 
> Sent: 30 January 2002 17:58
> To: Oleg Bartunov
> Cc: pgsql-admin@postgresql.org; Pgsql Hackers
> Subject: Re: [HACKERS] [ADMIN] postgresql under Windows is slow 
> 
> 
> Oleg Bartunov <oleg@sai.msu.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.


Re: [ADMIN] postgresql under Windows is slow

From
Oleg Bartunov
Date:
On Wed, 30 Jan 2002, Dave Page wrote:

>
>
> > -----Original Message-----
> > From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> > Sent: 30 January 2002 17:58
> > To: Oleg Bartunov
> > Cc: pgsql-admin@postgresql.org; Pgsql Hackers
> > Subject: Re: [HACKERS] [ADMIN] postgresql under Windows is slow
> >
> >
> > Oleg Bartunov <oleg@sai.msu.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@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Re: [ADMIN] postgresql under Windows is slow

From
Tom Lane
Date:
Oleg Bartunov <oleg@sai.msu.su> writes:
> What I can do to get more preformance ?

Sounds like the answer is "stop using Windows 98".

Now that Dave mentions it, I do recall that it was Great Bridge's
people who had gotten pretty much the same numbers from their TPC-C
benchmark on Cygwin as on Linux.  I'm quite sure they'd have been
using a current-at-the-time Windows ... so, either NT or W2K.
Probably NT but I can't say that for certain.

            regards, tom lane