Re: [ADMIN] postgresql under Windows is slow

> -----Original Message-----
> From: Oleg Bartunov [mailto:oleg(at)sai(dot)msu(dot)su]
> Sent: 31 January 2002 11:13
> To: Dave Page
> Cc: 'Tom Lane'; 'pgsql-admin(at)postgresql(dot)org'; 'Pgsql Hackers'
> Subject: Re: [HACKERS] [ADMIN] 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 ?

Yes you can compile it yourself under Cygwin, but there's not really any
point that I can see. I don't think it'll run any faster. I can't tell you
the name of the guy a Greatbridge at the moment as I can't seem to search
the archives right now.

Regards, Dave