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

From Mark Phillips
Subject Create database from template very slow
Date
Msg-id 4C4A7183-75F5-4B11-8CE1-93B1FA231BE7@mophilly.com
Whole thread Raw
Responses Re: Create database from template very slow  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
This is likely not a bug, so please point me in the right direction if that is the case.

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.

- Mark Phillips



pgsql-bugs by date:

Previous
From: MOHAN KUMAR DORAIRAJ
Date:
Subject: Re: BUG #16145: Not able to terminate active session
Next
From: "David G. Johnston"
Date:
Subject: Re: Create database from template very slow