From: Dalibor Sramek <dali@insula.cz>
To: pgsql-performance@postgresql.org
Subject: Low performance on Windows problem
Date: Tue, 13 Sep 2005 13:05:09 +0200
Message-ID: <20050913110509.GA52174@www.epot.cz> (raw)
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.htmhttp://sparxsystems.com.au/EAUserGuide/index.html?setupapostgresqlodbcdriver.htm
--
Dalibor Sramek http://www.insula.cz/dali \ In the eyes of cats
/ dalibor.sramek@insula.cz \ all things
/ >H blog http://www.transhumanismus.cz/blog.php \ belong to cats.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dali@insula.cz
Subject: Re: Low performance on Windows problem
In-Reply-To: <20050913110509.GA52174@www.epot.cz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox