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 9DA4153E6D for ; Thu, 28 Apr 2005 12:01:21 -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 51473-08 for ; Thu, 28 Apr 2005 15:01:17 +0000 (GMT) Received: from priv-edtnes56.telusplanet.net (outbound01.telus.net [199.185.220.220]) by svr1.postgresql.org (Postfix) with ESMTP id 9496553BB3 for ; Thu, 28 Apr 2005 12:00:59 -0300 (ADT) Received: from localhost ([199.185.220.240]) by priv-edtnes56.telusplanet.net (InterMail vM.6.01.04.04 201-2131-118-104-20050224) with ESMTP id <20050428150053.GSEX4406.priv-edtnes56.telusplanet.net@localhost>; Thu, 28 Apr 2005 09:00:53 -0600 Received: from 209.17.183.249 ( [209.17.183.249]) as user a3a18850@192.168.200.1 by webmail.telus.net with HTTP; Thu, 28 Apr 2005 08:00:53 -0700 Message-ID: <1114700453.4270faa5894b1@webmail.telus.net> Date: Thu, 28 Apr 2005 08:00:53 -0700 From: Mischa Sandberg To: Richard Rowell Cc: pgsql-performance@postgresql.org, Mark Rinaudo Subject: Re: Suggestions for a data-warehouse migration routine References: <1114618034.7543.36.camel@richard> In-Reply-To: <1114618034.7543.36.camel@richard> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.1-cvs X-Originating-IP: 209.17.183.249 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.082 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_POST, FORGED_RCVD_HELO X-Spam-Level: * X-Archive-Number: 200504/760 X-Sequence-Number: 12157 Quoting Richard Rowell : > I've ported enough of my companies database to Postgres to make > warehousing on PG a real possibility. I thought I would toss my > data > migration architecture ideas out for the list to shoot apart.. > [...] Not much feedback required. Yes, dropping the entire database is faster and simpler. If your database is small enough that you can rebuild it from scratch every time, go for it. Yes, vacuum analyze required; creating indexes alone does not create statistics.