"Clark C. Evans" <cce@xxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general