John A Meinel <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to