Обсуждение: How to cache a non-unique index?

Hi,

I have added a catalog table with an index on a non-unique column. I
want to cache this non-unique index like other unique indexes in
syscache. Is there any way to cache a non-unique index? I just want the
index to reside in the memory to speed up the index lookup. Thank you!

Wang

Xin Wang <andywx@gmail.com> writes:
> I have added a catalog table with an index on a non-unique column. I
> want to cache this non-unique index like other unique indexes in
> syscache. Is there any way to cache a non-unique index?

No, not with syscache.
        regards, tom lane