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 54AD5529F9 for ; Wed, 27 Jul 2005 15:28:45 -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 28819-04 for ; Wed, 27 Jul 2005 18:28:44 +0000 (GMT) Received: from mail63.csoft.net (leary3.csoft.net [63.111.22.74]) by svr1.postgresql.org (Postfix) with SMTP id 011AA529EF for ; Wed, 27 Jul 2005 15:28:43 -0300 (ADT) Received: (qmail 4263 invoked by uid 1112); 27 Jul 2005 18:28:44 -0000 Date: Wed, 27 Jul 2005 13:28:44 -0500 (EST) From: Kris Jurka X-X-Sender: books@leary.csoft.net To: Josh Berkus Cc: pgsql-performance@postgresql.org, John A Meinel , bizgres-general , Dan Harris Subject: Re: [Bizgres-general] Re: faster INSERT with possible In-Reply-To: <200507270929.10251.josh@agliodbs.com> Message-ID: References: <200507270929.10251.josh@agliodbs.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII 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: 200507/418 X-Sequence-Number: 13659 On Wed, 27 Jul 2005, Josh Berkus wrote: > b) you can't index a temp table. > jurka# create temp table t (a int); CREATE jurka# create index myi on t(a); CREATE