[GENERAL] Slow database creation

2009-02-10 Thread Rob Richardson
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

Re: [GENERAL] Slow database creation

2009-02-10 Thread Richard Huxton
Rob Richardson wrote: 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

Re: [GENERAL] Slow database creation

2009-02-10 Thread Andrej
2009/2/11 Rob Richardson rob.richard...@rad-con.com: [... snipped ...] 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

Re: [GENERAL] Slow database creation

2009-02-10 Thread Alban Hertroys
On Feb 10, 2009, at 3:09 PM, Rob Richardson wrote: 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