Skip site navigation (1) Skip section navigation (2)

Re: [ADMIN] postgresql under Windows is slow

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'Oleg Bartunov'" <oleg(at)sai(dot)msu(dot)su>
Cc: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>, "'Pgsql Hackers'" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [ADMIN] postgresql under Windows is slow
Date: 2002-01-31 11:47:32
Message-ID: FED2B709E3270E4B903EB0175A49BCB10B52F2@dogbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers

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

Responses

pgsql-hackers by date

Next:From: Oleg BartunovDate: 2002-01-31 11:50:58
Subject: Re: [HACKERS] postgresql under Windows is slow
Previous:From: Oleg BartunovDate: 2002-01-31 11:13:08
Subject: Re: [HACKERS] postgresql under Windows is slow

pgsql-admin by date

Next:From: Oleg BartunovDate: 2002-01-31 11:50:58
Subject: Re: [HACKERS] postgresql under Windows is slow
Previous:From: Oleg BartunovDate: 2002-01-31 11:13:08
Subject: Re: [HACKERS] postgresql under Windows is slow

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group