[HACKERS] How to cache a non-unique index?

2009-12-07 Thread Xin Wang 
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


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] How to cache a non-unique index?

2009-12-07 Thread Tom Lane 
Xin Wang and...@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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers