Thread: postgresql under Windows is slow
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
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
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
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 >
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
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, 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
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