Re: Are statistics gathered on function indexes?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ray Ontko <rayo(at)ontko(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Are statistics gathered on function indexes?
Date: 2002-10-19 03:13:20
Message-ID: 15121.1034997200@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Casey Allen Shobe 2002-10-20 21:13:05 User/group association
Previous Message Ovidiu Feodorov 2002-10-18 22:15:53 Postgres 7.2.3 initdb failure on IRIX 6.5