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 sec
2009/2/11 Rob Richardson :
> [... 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 longer
> than five second
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 Pro
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 o
