Обсуждение: postgresql under Windows is slow

Поиск
Список
Период
Сортировка

postgresql under Windows is slow

От
Oleg Bartunov
Дата:
Hi,

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.

    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

Re: [ADMIN] postgresql under Windows is slow

От
Tom Lane
Дата:
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.

            regards, tom lane

Re: [ADMIN] postgresql under Windows is slow

От
"Matthew T. O'Connor"
Дата:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Wednesday 30 January 2002 11:58 am, Tom Lane wrote:
> 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.

We have a few developers that run Apache, PHP, Postgresql on Win2k and we 
have definitely seen postgres be a good bit slower on Windows.  Have never 
benchmarked it however.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE8WD6K8BXvT14W9HARAh+GAJwKqs2k8fwJYooenFCqHMMgXr0DjQCcCaQr
bQxY10HunpD2+IACH/L0yas=
=p8Mb
-----END PGP SIGNATURE-----

Re: [ADMIN] postgresql under Windows is slow

От
Andy Ruhl
Дата:
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?

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.

Andy

acruhl@sdf.lonestar.org
SDF Public Access UNIX System - http://sdf.lonestar.org