Re: Create database from template very slow - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: Create database from template very slow
Date
Msg-id CAKFQuwbJByU_9oRhOLrsqQ7TZa1=gc+8YPq_4ZUN4rbig0N4-w@mail.gmail.com
Whole thread Raw
In response to Create database from template very slow  (Mark Phillips <mark.phillips@mophilly.com>)
Responses Re: Create database from template very slow  (Thomas Munro <thomas.munro@gmail.com>)
List pgsql-bugs
On Tue, Dec 3, 2019 at 9:27 PM Mark Phillips <mark.phillips@mophilly.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.

pgsql-bugs by date:

Previous
From: Mark Phillips
Date:
Subject: Create database from template very slow
Next
From: Thomas Munro
Date:
Subject: Re: Create database from template very slow