| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Mark Phillips <mark(dot)phillips(at)mophilly(dot)com> |
| Cc: | PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Create database from template very slow |
| Date: | 2019-12-04 04:51:14 |
| Message-ID: | CAKFQuwbJByU_9oRhOLrsqQ7TZa1=gc+8YPq_4ZUN4rbig0N4-w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Tue, Dec 3, 2019 at 9:27 PM Mark Phillips <mark(dot)phillips(at)mophilly(dot)com>
wrote:
> This is likely not a bug, so please point me in the right direction if
> that is the case.
>
The -general list is you best choice if you know its not a bug but don't
know where else to send the email.
> In our application, a copy of the local database is made at launch using...
> CREATE DATABASE myCopy FROM TEMPLATE currentDB;
>
> On linux and MacOS this operation completed in 5 seconds or so. On Windows
> (10 at present) it takes over a minute or more.
>
> I would like to understand why this would be, and what might be done to
> speed it up on Windows.
>
>
Less capable hardware on the Windows box? Use better hardware? This isn't
my area of expertise but I'm doubtful that any significant fault/difference
exists within the PostgreSQL software. Is the data involved identical?
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2019-12-04 05:16:43 | Re: Create database from template very slow |
| Previous Message | Mark Phillips | 2019-12-04 04:17:40 | Create database from template very slow |