[Tobias Brox - Tue at 11:02:07AM +0800] > I read in the manual today: > > Indexes are not used for IS NULL clauses by default. The best way to use > indexes in such cases is to create a partial index using an IS NULL > predicate.
I have summarized this thread in a postgresql doc user comment, posted at http://www.postgresql.org/docs/current/interactive/sql-createindex.html I think it's a good thing to do, since it can be difficult to search the mailing list archives :-) -- Tobias Brox, Beijing ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly