How to cache a non-unique index?

From: Xin Wang <andywx(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: How to cache a non-unique index?
Date: 2009-12-07 13:50:09
Message-ID: 4B1D0811.9060405@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2009-12-07 14:24:55 Re: EXPLAIN BUFFERS
Previous Message marcin mank 2009-12-07 13:33:36 bug: fuzzystrmatch levenshtein is wrong