X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9DBE0DB4C1 for ; Mon, 31 Oct 2005 13:51:48 -0400 (AST) 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 23901-08 for ; Mon, 31 Oct 2005 17:51:46 +0000 (GMT) Received: from tbmail.tradebot.com (Tradebot-Systems-1096753.cust-rtr.swbell.net [68.90.170.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4D9E8DB4FF for ; Mon, 31 Oct 2005 13:51:45 -0400 (AST) Received: from 192.168.200.29 ([192.168.200.29]) by tbmail.tradebot.com ([192.168.1.50]) with Microsoft Exchange Server HTTP-DAV ; Mon, 31 Oct 2005 17:51:46 +0000 Received: from krb06 by TBMAIL; 31 Oct 2005 11:51:46 -0600 Subject: Re: 8.x index insert performance From: Kelly Burkhart To: Merlin Moncure Cc: pgsql-performance@postgresql.org In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3417DD725@Herge.rcsinc.local> References: <6EE64EF3AB31D5448D0007DD34EEB3417DD725@Herge.rcsinc.local> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Mon, 31 Oct 2005 11:51:46 -0600 Message-Id: <1130781106.7026.46.camel@krb06.tradebot.com> Mime-Version: 1.0 X-Mailer: Evolution 2.2.1 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.024 required=5 tests=[AWL=0.023, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.024 X-Spam-Level: X-Archive-Number: 200510/474 X-Sequence-Number: 15242 On Mon, 2005-10-31 at 12:32 -0500, Merlin Moncure wrote: > well, can you defer index generation until after loading the set (or use > COPY?) I cannot defer index generation. We are using the copy API. Copying 10000 rows in a batch. > > if that index is causing the problem, you may want to consider setting > up partial index to exclude null values. This is a single column index. I assumed that null column values were not indexed. Is my assumption incorrect? -K