Slow database creation - Mailing list pgsql-general
Greetings!
My company has an application that runs on one machine and reads a PostgreSQL database that may be located on another. I have a test version of this application and a copy of their database on my computer. A problem that the application solves on my machine in under 10 seconds takes over 20 minutes on the customer's system. I believe the reason is that data transfer between machines is extremely slow, but I don't know why. This is not a large database. The largest queries return 300 records with 50 fields per record, and 1700 records from a table with 6 fields per record.
In order to test without disturbing the customer's production, I created a copy of their production database on the production server. I often create test databases, and I've never seen the CREATE DATABASE command take longer than five seconds. On the customer's production machine, the command took 167 seconds.
Can anyone explain why it would take 167 seconds to create a database? I am hoping that it's the same reason that data access is slowing our application by a factor of about 200.
The customer's machines run Windows Server 2003. My machine runs Windows XP Professional. The application is written in C++.
Rob Richardson
Product Engineer Software
RAD-CON, Inc.
TECHNOLOGY: Innovative & Proven
Phone : +1.216.706.8905
Fax: +1.216.221.1135
Website: www.RAD-CON.com
E-mail: rob.richardson@RAD-CON.com
Attachment
pgsql-general by date: