| From: | Andrej <andrej(dot)groups(at)gmail(dot)com> |
|---|---|
| To: | Rob Richardson <Rob(dot)Richardson(at)rad-con(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Slow database creation |
| Date: | 2009-02-10 17:41:50 |
| Message-ID: | b35603930902100941sdbc30edp459b9129cd4cb056@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2009/2/11 Rob Richardson <Rob(dot)Richardson(at)rad-con(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2009-02-10 17:45:27 | Re: does anyone know what to use in pg_hba.conf that will allow me to run cronjobs with pg_dump? |
| Previous Message | Jonathan Vanasco | 2009-02-10 16:52:23 | does anyone know what to use in pg_hba.conf that will allow me to run cronjobs with pg_dump? |