Thread: Re: [ADMIN] postgresql under Windows is slow

Re: [ADMIN] 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: [ADMIN] postgresql under Windows is slow

From
Adrian Phillips
Date:
>>>>> "Oleg" == Oleg Bartunov <oleg@sai.msu.su> writes:
   Oleg> On Thu, 31 Jan 2002, Andy Ruhl wrote:   >> On Wed, 30 Jan 2002, Oleg Bartunov wrote:   >>    >> > anybody has
anexperience how is stable postgresql under   >> Windows system ?  > I tried postgresq 7.1 under Cygwin, Windows   >>
98and was dissapointed > by very bad performance. Are there   >> something I could tune ?  > I got 250 sel/sec on
simpleselect   >> from table with 500 rows !  > Under Linux I have 2500 sel/sec.   >>    >> What are your plans for
postgresqlon Windows? Just by the   >> nature of the OS, I'd never expect too much performance from a   >> Cygwin app,
especiallyone like postgresql. Do you plan on   >> running it on 98 in a production manner?
 
   Oleg> even worse, we have to port our application to Windows and   Oleg> it should run under W95..XP on different
hardware(PII   Oleg> ...). It'll run in single-user environment (thank   Oleg> goodness). Database will have about
20-30K rows.
 

For starters, check out the Cywgin FAQ :-

http://cygwin.com/faq/faq.html#TOC75 (How is fork implemented)

and the Cygwin User's guide, especially :-

Highlights of Cygwin Functionality/Process Creation

There are also some discussions about fork and vfork in the mailing
list archives, and I see that there have been some changes to do with
vfork during the last year or so but don't know whether that is
applicable to Postgresql.

Sincerely

Adrian Phillips

-- 
Your mouse has moved.
Windows NT must be restarted for the change to take effect.
Reboot now?  [OK]


Re: [ADMIN] 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: [ADMIN] postgresql under Windows is slow

From
Hannu Krosing
Date:
On Thu, 2002-01-31 at 21:33, Oleg Bartunov wrote:
> 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 can be thet task switching behaviour of Win9x in not very best and
thus too much time is spent switching between client and server :)

To test this theory you could dry to rerun your benchmarks by sending
more queries in one request to lower the switching overhead. When you
run 250 single selects/sec you need to switch between client and server
process 500x/sec. Try sending your queries 10 at a time and see what you
get, or for even cleaner test results use separate server comuter

> It'll run in single-user environment (thank goodness).

It could help if you could run in a single process perhaps by putting
your whole application logic in pl/perl (or will this still use
_another_ backent to execute it's queries.

> Database will have about 20-30 K rows.

Do you really need all that performance on win9x ?

-------------
Hannu