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