Обсуждение: Re: [ADMIN] postgresql under Windows is slow

> -----Original Message-----
> From: Oleg Bartunov [mailto:oleg@sai.msu.su] 
> Sent: 31 January 2002 11:13
> To: Dave Page
> Cc: 'Tom Lane'; 'pgsql-admin@postgresql.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@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 ?

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

On Thu, 31 Jan 2002, Dave Page wrote:

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

Ohh, this problem shoul dbe addressed to Marc. It's shame we can't search
mailing archive.


>
> Regards, Dave
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>

    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