Re: Are statistics gathered on function indexes? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Are statistics gathered on function indexes?
Date
Msg-id 15121.1034997200@sss.pgh.pa.us
Whole thread Raw
In response to Re: Are statistics gathered on function indexes?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Awhile back I said:
> Oh, I see it: range selectivity double-excludes NULLs.  See the comment
> for clauselist_selectivity in src/backend/optimizer/path/clausesel.c.
> The individual estimates for the two component comparison operators
> each exclude nulls, and when we merge them together we get the wrong
> answer.

Just FYI, I have fixed this for 7.3.

            regards, tom lane

pgsql-admin by date:

Previous
From: Ovidiu Feodorov
Date:
Subject: Postgres 7.2.3 initdb failure on IRIX 6.5
Next
From: Casey Allen Shobe
Date:
Subject: User/group association