Re: Can anyone explain this: duplicate dbs.

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Can anyone explain this: duplicate dbs.
Дата
Msg-id 7690.1116990161@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Can anyone explain this: duplicate dbs.  (John A Meinel <john@arbash-meinel.com>)
Список pgsql-performance
John A Meinel <john@arbash-meinel.com> writes:
> By the way, I think doing:

> CREATE DATABASE tempdb WITH TEMPLATE = originaldb;

> Is a much faster way of doing dump and load. I *think* it would recreate
> indexes, etc. If it just does a copy it may not show the dump/restore
> improvement.

CREATE DATABASE just does a physical copy, so it won't do anything at
all for bloat issues.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Can anyone explain this: duplicate dbs.
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Can anyone explain this: duplicate dbs.