X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8C89B5285C for ; Wed, 25 May 2005 00:34:05 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 72566-06 for ; Wed, 25 May 2005 03:34:03 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.197.194]) by svr1.postgresql.org (Postfix) with SMTP id BF2315282B for ; Wed, 25 May 2005 00:34:02 -0300 (ADT) Received: (qmail 16889 invoked by uid 500); 25 May 2005 03:32:46 -0000 Date: Tue, 24 May 2005 22:32:46 -0500 From: Bruno Wolff III To: John A Meinel Cc: SpaceBallOne , pgsql-performance@postgresql.org Subject: Re: Can anyone explain this: duplicate dbs. Message-ID: <20050525033246.GB15626@wolff.to> Mail-Followup-To: Bruno Wolff III , John A Meinel , SpaceBallOne , pgsql-performance@postgresql.org References: <4293E553.6070400@arbash-meinel.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <4293E553.6070400@arbash-meinel.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.009 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/386 X-Sequence-Number: 12550 On Tue, May 24, 2005 at 21:39:15 -0500, John A Meinel 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.