Re: pg_index.indislossy

Started by Hannu Krosingalmost 25 years ago2 messageshackers
Jump to latest
#1Hannu Krosing
hannu@tm.ee

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

#2Bruce Momjian
bruce@momjian.us
In reply to: Hannu Krosing (#1)

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 ;)

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