John A Meinel <john(at)arbash-meinel(dot)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