Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBJ0Q2629090 for ; Mon, 18 Dec 2000 19:26:02 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id eBJ0PcC02486; Mon, 18 Dec 2000 19:25:38 -0500 (EST) To: Hannu Krosing cc: Oleg Bartunov , Bruce Momjian , PostgreSQL-development Subject: Re: Who is a maintainer of GiST code ? In-reply-to: <3A3EA5F2.DF22E9E6@tm.ee> References: <1642.977173813@sss.pgh.pa.us> <3A3EA5F2.DF22E9E6@tm.ee> Comments: In-reply-to Hannu Krosing message dated "Tue, 19 Dec 2000 02:04:02 +0200" Date: Mon, 18 Dec 2000 19:25:38 -0500 Message-ID: <2483.977185538@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200012/783 X-Sequence-Number: 2304 Hannu Krosing writes: > and I can't see why btree stores them (as it seems to do judging by the > index file size) - at least it does not use it for searching for "IS > NULL" That's another thing that needs improvement ;-). Seems to me it should be able to do that. The reason why btree *has* to be able to deal with null entries is to cope with multi-column indexes; you don't want it refusing to index a row at all just because some of the columns are null. The others don't currently handle multi-column indexes, so they're not really forced to deal with that issue.