Re: Slow database creation - Mailing list pgsql-general

From Andrej
Subject Re: Slow database creation
Date
Msg-id b35603930902100941sdbc30edp459b9129cd4cb056@mail.gmail.com
Whole thread Raw
In response to Slow database creation  ("Rob Richardson" <Rob.Richardson@rad-con.com>)
List pgsql-general
2009/2/11 Rob Richardson <Rob.Richardson@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 longer
> than five seconds.  On the customer's production machine, the command took
> 167 seconds.
>  [... snipped ...]
> The customer's machines run Windows Server 2003.  My machine runs Windows XP
> Professional.  The application is written in C++.

Now I'm not a windows-expert by any stretch of the imagination,
but could there be some anti-virus products involved at the customer
site?


> Rob Richardson
> Product Engineer Software

Cheers,
Andrej

pgsql-general by date:

Previous
From: Jonathan Vanasco
Date:
Subject: does anyone know what to use in pg_hba.conf that will allow me to run cronjobs with pg_dump?
Next
From: Richard Huxton
Date:
Subject: Re: does anyone know what to use in pg_hba.conf that will allow me to run cronjobs with pg_dump?