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 EF830DB5AB for ; Mon, 31 Oct 2005 16:59:51 -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 98742-07 for ; Mon, 31 Oct 2005 20:59:49 +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 247A4DB577 for ; Mon, 31 Oct 2005 16:59:49 -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 20:59:51 +0000 Received: from krb06 by TBMAIL; 31 Oct 2005 14:59:51 -0600 Subject: Re: 8.x index insert performance From: Kelly Burkhart To: Tom Lane Cc: mark@mark.mielke.cc, Merlin Moncure , pgsql-performance@postgresql.org In-Reply-To: <18647.1130790629@sss.pgh.pa.us> References: <6EE64EF3AB31D5448D0007DD34EEB3417DD725@Herge.rcsinc.local> <20051031193547.GA3311@mark.mielke.cc> <18647.1130790629@sss.pgh.pa.us> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Mon, 31 Oct 2005 14:59:51 -0600 Message-Id: <1130792391.7026.55.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.022 required=5 tests=[AWL=0.021, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.022 X-Spam-Level: X-Archive-Number: 200510/480 X-Sequence-Number: 15248 On Mon, 2005-10-31 at 15:30 -0500, Tom Lane wrote: > mark@mark.mielke.cc writes: > > I've been trying to figure out whether null values are indexed or not from > > the documentation. I was under the impression, that null values are not > > stored in the index. > > You're mistaken, at least with regard to btree indexes. Ha! So I'm creating an index 98% full of nulls! Looks like this is easily fixed with partial indexes. -K