[ADMIN] postgresql under Windows is slow

2002-01-30 Thread 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/s

Re: [ADMIN] postgresql under Windows is slow

2002-01-30 Thread Tom Lane
Oleg Bartunov <[EMAIL PROTECTED]> 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

Re: [ADMIN] postgresql under Windows is slow

2002-01-30 Thread Joshua Franklin
Oleg Bartunov <[EMAIL PROTECTED]> 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 yo

Re: [ADMIN] postgresql under Windows is slow

2002-01-31 Thread Henshall, Stuart - WCP
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 c

Re: [ADMIN] postgresql under Windows is slow

2002-01-31 Thread 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

Re: [ADMIN] postgresql under Windows is slow

2002-01-31 Thread Andy Ruhl
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 day

Re: [ADMIN] postgresql under Windows is slow

2002-01-31 Thread Oleg Bartunov
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 ?

Re: [ADMIN] postgresql under Windows is slow

2002-01-31 Thread Eduardo Caillava
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 e

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

2002-01-31 Thread Oleg Bartunov
On Wed, 30 Jan 2002, Dave Page wrote: > > > > -Original Message- > > From: Tom Lane [mailto:[EMAIL PROTECTED]] > > Sent: 30 January 2002 17:58 > > To: Oleg Bartunov > > Cc: [EMAIL PROTECTED]; Pgsql Hackers > > Subject: Re: [HACKERS

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

2002-01-31 Thread Oleg Bartunov
On Thu, 31 Jan 2002, Dave Page wrote: > > > Who is this guy ? What I can do to get more preformance ? > > Is't possible to compile 7.2 sources under Cygwin ? Do I need > > to do something special ? > > Yes you can compile it yourself under Cygwin, but there's not really any > point that I can see

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

2002-01-31 Thread Tom Lane
Oleg Bartunov <[EMAIL PROTECTED]> writes: > What I can do to get more preformance ? Sounds like the answer is "stop using Windows 98". Now that Dave mentions it, I do recall that it was Great Bridge's people who had gotten pretty much the same numbers from their TPC-C benchmark on Cygwin as on L