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

Re: [HACKERS] postgresql under Windows is slow

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
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: [HACKERS] postgresql under Windows is slow
Date: 2002-01-31 11:13:08
Message-ID: Pine.GSO.4.44.0201311411400.18486-100000@ra.sai.msu.su (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
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


In response to

Responses

pgsql-hackers by date

Next:From: Dave PageDate: 2002-01-31 11:47:32
Subject: Re: [ADMIN] postgresql under Windows is slow
Previous:From: Hiroshi InoueDate: 2002-01-31 10:37:18
Subject: Re: RFD: schemas and different kinds of Postgres objects

pgsql-admin by date

Next:From: Dave PageDate: 2002-01-31 11:47:32
Subject: Re: [ADMIN] postgresql under Windows is slow
Previous:From: Joshua FranklinDate: 2002-01-31 00:13:05
Subject: Re: postgresql under Windows is slow

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