X-Original-To: pgsql-sql@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 46AEC92575F for ; Sun, 25 May 2003 18:13:37 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 47447-04 for ; Sun, 25 May 2003 18:13:35 -0400 (EDT) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by developer.postgresql.org (Postfix) with ESMTP id 6BEE592571B for ; Sun, 25 May 2003 18:13:35 -0400 (EDT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3067595 for pgsql-sql@postgresql.org; Sun, 25 May 2003 15:13:38 -0700 Content-Type: text/plain; charset="us-ascii" From: Josh Berkus Organization: Aglio Database Solutions To: pgsql-sql@postgresql.org Subject: Quick question regarding indexes and NULLs in 7.3.3 -> 7.4 Date: Sun, 25 May 2003 15:11:47 -0700 User-Agent: KMail/1.4.3 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200305251511.47341.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/489 X-Sequence-Number: 13654 Folks, I'm updating Joy of Index, and I wanted to clear something up. In 7.3.3, and in 7.4 CVS, will IS NOT NULL queries use a regular index if NULLs are sufficiently uncommon, or does this still require an IS NULL partial index as it did in 7.2.x? I don't want to mislead readers .... -- Josh Berkus Aglio Database Solutions San Francisco