Re: Can anyone explain this: duplicate dbs.

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: Can anyone explain this: duplicate dbs.
Дата
Msg-id 20050525033246.GB15626@wolff.to
обсуждение исходный текст
Ответ на Re: Can anyone explain this: duplicate dbs.  (John A Meinel <john@arbash-meinel.com>)
Список pgsql-performance
On Tue, May 24, 2005 at 21:39:15 -0500,
  John A Meinel <john@arbash-meinel.com> wrote:
>
> 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.

You need to be careful when doing this. See section 18.3 of the 8.0 docs
for caveats.

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Can anyone explain this: duplicate dbs.
Следующее
От: Philip Hallstrom
Дата:
Сообщение: Re: Need help to decide Mysql vs Postgres