Re: How to cache a non-unique index?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Xin Wang <andywx(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: How to cache a non-unique index?
Date: 2009-12-07 15:32:18
Message-ID: 4420.1260199938@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Xin Wang <andywx(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2009-12-07 15:42:47 Re: bug: json format and auto_explain
Previous Message Kevin Grittner 2009-12-07 15:32:15 Re: tsearch parser inefficiency if text includes urls or emails - new version