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