Low performance on Windows problem

From: Dalibor Sramek <dali(at)insula(dot)cz>
To: pgsql-performance(at)postgresql(dot)org
Subject: Low performance on Windows problem
Date: 2005-09-13 11:05:09
Message-ID: 20050913110509.GA52174@www.epot.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello.

I would like to build a shared repository for Enterprise Architect
(http://www.sparxsystems.com.au/ea.htm) using PostgreSQL. I have done it
before with Linux and FreeBSD servers and everything was working out of the
box. The repository is pretty simple database with less than 100 tables (the
schema is at
http://www.sparxsystems.com.au/downloads/corp/Postgres_Basemodel.sql).

The problem is that at the moment I have only a Windows XP "server" at my
disposal. I have installed PostgreSQL 8.0.3 for Windows and set the
repository up. Unfortunately the performance is unacceptable: every
operation with the model stored in the repository is by the order of
magnitude slower than on the FreeBSD server with half as good hardware.
(BTW CPU load is nearly 0, network load is under 5%, the machine has 1GB
RAM and the database size is 14MB.)

I have tried to:
- tweak the postgresql.conf - no apparent change
- kill all unnecessary services - no apparent change
- install MySQL on the same machine to compare - it is as fast as PostgreSQL
on FreeBSD (= way faster than PG on the machine)

Anyway I believe the problem is in the Win PostgreSQL server but I have no
idea where to look and neither do I have much time to spend.
(Also I really do not want to run MySQL ;-)

Any suggestions are welcome.

Thanks

Dalibor Sramek

P.S.

More information about EA PGSQL repositories:
http://sparxsystems.com.au/resources/corporate/
http://sparxsystems.com.au/EAUserGuide/index.html?connecttoapostgresqlreposi.htm
http://sparxsystems.com.au/EAUserGuide/index.html?setupapostgresqlodbcdriver.htm

--
Dalibor Sramek http://www.insula.cz/dali \ In the eyes of cats
/ dalibor(dot)sramek(at)insula(dot)cz \ all things
/ >H blog http://www.transhumanismus.cz/blog.php \ belong to cats.

Browse pgsql-performance by date

  From Date Subject
Next Message Bouchard Sylvie 2005-09-13 11:17:27 Opencms6 ans Postgres8
Previous Message Ron Peacetree 2005-09-13 05:02:16 Re: Performance considerations for very heavy INSERT