"Clark C. Evans" <cce(at)clarkevans(dot)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