Re: pg_index.indislossy
Bruce Momjian wrote:
Can someone tell me what we use indislossy for?
IIRC it means that if you get something by this index you must check
again in the actual data
I think that at least the GIST intarray (actually intset) methods use
it.
So you probably should _not_ remove it ;)
------------------
Hannu
Import Notes
Reference msg id not found: 200105142035.f4EKZns27145@candle.pha.pa.us
Bruce Momjian wrote:
Can someone tell me what we use indislossy for?
IIRC it means that if you get something by this index you must check
again in the actual dataI think that at least the GIST intarray (actually intset) methods use
it.So you probably should _not_ remove it ;)
I did a search and found it used only a few places. I do not see it
used as part of GIST. My rememberance is that it is involved in partial
indexes, where you index only certain values in a column. It was an old
idea that was never working in PostgreSQL.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026