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

Re: postgresql under Windows is slow

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Andy Ruhl <acruhl(at)sdf(dot)lonestar(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org, Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: postgresql under Windows is slow
Date: 2002-01-31 16:33:28
Message-ID: Pine.GSO.4.44.0201311915480.18486-100000@ra.sai.msu.su (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackers
On Thu, 31 Jan 2002, Andy Ruhl wrote:

> On Wed, 30 Jan 2002, Oleg Bartunov wrote:
>
> > 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.
>
> What are your plans for postgresql on Windows? Just by the nature of the
> OS, I'd never expect too much performance from a Cygwin app, especially
> one like postgresql. Do you plan on running it on 98 in a production
> manner?

even worse, we have to port our application to Windows and it should
run under W95..XP on different hardware (PII ...). It'll run in
single-user environment (thank goodness). Database will have about
20-30 K rows.


>
> My own experience is that postgresql runs quite a bit slower on WinMe than
> my NetBSD box (same hardware), but I don't consider that to be a problem.
>

Did you make some special tuning ? btw, what's about locale support ?

> Andy
>
> acruhl(at)sdf(dot)lonestar(dot)org
> SDF Public Access UNIX System - http://sdf.lonestar.org
>

	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: Bill StudenmundDate: 2002-01-31 16:33:50
Subject: Re: RFD: schemas and different kinds of Postgres objects
Previous:From: Bill StudenmundDate: 2002-01-31 16:31:03
Subject: Re: RFD: schemas and different kinds of Postgres objects

pgsql-admin by date

Next:From: Peter EisentrautDate: 2002-01-31 16:35:04
Subject: Re: [SQL] Regression tests failed on 7.2rc2
Previous:From: Andy RuhlDate: 2002-01-31 16:13:38
Subject: Re: postgresql under Windows is slow

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