Re: CLONE DATABASE (with copy on write?) - Mailing list pgsql-general

From Tom Lane
Subject Re: CLONE DATABASE (with copy on write?)
Date
Msg-id 6930.1321202704@sss.pgh.pa.us
Whole thread Raw
In response to Re: CLONE DATABASE (with copy on write?)  ("Clark C. Evans" <cce@clarkevans.com>)
Responses Re: CLONE DATABASE (with copy on write?)  ("Clark C. Evans" <cce@clarkevans.com>)
List pgsql-general
"Clark C. Evans" <cce@clarkevans.com> writes:
> Even so, the CREATE DATABASE... WITH TEMPLATE still has a set of
> additional issues with it.  It ties up the hard drive with activity
> and then extra space while it duplicates data.  Further, it causes
> the shared memory cache to be split between the original and the
> replica, this causes both databases to be much slower.  Finally,
> it creates a ton of WAL traffic (perhaps we could suspend this?)

That last claim is false ...

            regards, tom lane

pgsql-general by date:

Previous
From: Ludo Smissaert
Date:
Subject: Preserving ORDER of TEMP Tables during transaction
Next
From: David Johnston
Date:
Subject: Re: Preserving ORDER of TEMP Tables during transaction