Skip site navigation (1) Skip section navigation (2)

Re: Can anyone explain this: duplicate dbs.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: John A Meinel <john(at)arbash-meinel(dot)com>
Cc: SpaceBallOne <space_ball_one(at)hotmail(dot)com>,pgsql-performance(at)postgresql(dot)org
Subject: Re: Can anyone explain this: duplicate dbs.
Date: 2005-05-25 03:02:41
Message-ID: 7690.1116990161@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

pgsql-performance by date

Next:From: Bruno Wolff IIIDate: 2005-05-25 03:32:46
Subject: Re: Can anyone explain this: duplicate dbs.
Previous:From: Tom LaneDate: 2005-05-25 03:01:28
Subject: Re: Can anyone explain this: duplicate dbs.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group