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 4762014B281C for ; Wed, 11 Aug 2004 01:13:19 -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 67717-08 for ; Wed, 11 Aug 2004 04:13:12 +0000 (GMT) Received: from diablo.OntheNet.com.au (diablo.OntheNet.com.au [203.10.89.2]) by svr1.postgresql.org (Postfix) with ESMTP id ECB9B14B2824 for ; Wed, 11 Aug 2004 01:13:10 -0300 (ADT) Received: from [192.168.0.114] (imp3.dsl.onthenet.net [203.144.21.139]) by diablo.OntheNet.com.au (8.12.10/8.12.10) with ESMTP id i7B4D84G018093 for ; Wed, 11 Aug 2004 14:13:09 +1000 (EST) Message-ID: <41199C4C.9040308@wildcash.com> Date: Wed, 11 Aug 2004 14:10:52 +1000 From: Rudi Starcevic Reply-To: tech@wildcash.com Organization: Internet Media Productions User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7) Gecko/20040616 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Bulk Insert and Index use References: <41195462.9090303@wildcash.com> In-Reply-To: X-Enigmail-Version: 0.85.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/146 X-Sequence-Number: 7782 Hi, > In an attempt to throw the authorities off his trail, tech@wildcash.com (Rudi Starcevic) transmitted: > A minute for your thoughts and/or suggestions would be great. Heh heh .... > Could you give a more concrete example? E.g. - the DDL for the > table(s), most particularly. Thanks, I didn't add the DDL as I though it may make my question too long. I have the DDL at another office so I'll pick up this email thread when I get there in a couple hours. > At first guess, I think you're worrying about a nonissue. Each insert > will lead to a _modification_ of the various indices, which costs > _something_, but which is WAY less expensive than creating each index > from scratch. Very interesting, modification and creation. I will post another email later today. Many thanks. -- Regards, Rudi. Internet Media Productions