Thread: postgresql under Windows is slow

postgresql under Windows is slow

From
Oleg Bartunov
Date:
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: postgresql under Windows is slow

From
Tom Lane
Date:
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: postgresql under Windows is slow

From
Joshua Franklin
Date:
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.

As you might guess, Cygwin's speed depends heavily on
the version of Windows you are using and its
filesystem. I've heard
W2k/NTFS gives best performance for apps (like
pgsql) that require a lot of disk access.

__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com

Re: postgresql under Windows is slow

From
"Henshall, Stuart - WCP"
Date:
    Try using NT. I use 98 for development but it just drops the ball to
much for me to consider it for production (I've never had the regression
tests complete on 98, mind you I havn't tried particularly hard either). If
there is anyplace I would expect performance difference it would be in
connection times due to windows forking (or lack there of).
Cheers,
- Stuart

> -----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: 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.
>
>             regards, tom lane
>

Re: postgresql under Windows is slow

From
Andy Ruhl
Date:
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


Re: postgresql under Windows is slow

From
Andy Ruhl
Date:
On Thu, 31 Jan 2002, Oleg Bartunov wrote:

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

Ugh. Why pay for an OS these days? The free ones are getting too good.
It's amazing how entrenched Windows is.

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

It was a very quick, seat of the pants test. I made a junk schema with
some insert statements. I noticed that it took a few seconds longer to
finish on Windows than in NetBSD. Didn't do anything more than that. Don't
know about locale stuff, I never have to change that stuff...

Andy

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


Re: postgresql under Windows is slow

From
Oleg Bartunov
Date:
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@sdf.lonestar.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@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83


Re: postgresql under Windows is slow

From
"Eduardo Caillava"
Date:
hug... wakala...

I have PostgreSQL running in several boxes, since a clonic PIII400 , two
NetVista PIII800 and two NetFinity PIII 550.

All of them are Linux boxes, and obviously there are some performance
diferences related to the hardware, so I try hack hard to get best
performance posible in each case, but I never ever think to use a guindous
box to do serious work, especially if it is a guin98.

I hope you know that Linux 'n, FreeBSD are free and without costs, so why
pay for a cuasi-OS that is going to break your brain and make you live the
IT practice ? ? ?

Try it on Linux on the half hardware 'n tell us later.

Best for you and Greetings