X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 909D3D9637 for ; Sun, 25 Sep 2005 21:31:24 -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 51607-05 for ; Mon, 26 Sep 2005 00:31:20 +0000 (GMT) Received: from 217-20-115-93.internetserviceteam.com (217-20-115-93.internetserviceteam.com [217.20.115.93]) by svr1.postgresql.org (Postfix) with ESMTP id DBCC9D9632 for ; Sun, 25 Sep 2005 21:31:20 -0300 (ADT) Received: from [192.168.1.48] (177.Red-81-38-46.dynamicIP.rima-tde.net [81.38.46.177]) by 217-20-115-93.internetserviceteam.com (Postfix) with ESMTP id 479D139BE1 for ; Mon, 26 Sep 2005 01:47:21 +0200 (CEST) Message-ID: <4337413D.4040802@mediaroot.de> Date: Mon, 26 Sep 2005 01:30:53 +0100 From: Aldor User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Performance question: Restore + INDEX Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 required=5 tests=[none] X-Spam-Level: X-Archive-Number: 200509/285 X-Sequence-Number: 19022 Hi, I'm curious how other people do it: What is faster? 1. CREATE TABLE 2. restore data 3. CREATE INDEX or 1. CREATE TABLE 2. CREATE INDEX 3. restore data Thanks, Aldor