Re: CLONE DATABASE (with copy on write?)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: CLONE DATABASE (with copy on write?)
Дата
Msg-id 6930.1321202704@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: CLONE DATABASE (with copy on write?)  ("Clark C. Evans" <cce@clarkevans.com>)
Ответы Re: CLONE DATABASE (with copy on write?)  ("Clark C. Evans" <cce@clarkevans.com>)
Список 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 по дате отправления:

Предыдущее
От: Ludo Smissaert
Дата:
Сообщение: Preserving ORDER of TEMP Tables during transaction
Следующее
От: David Johnston
Дата:
Сообщение: Re: Preserving ORDER of TEMP Tables during transaction