| From: | Paul Ramsey <pramsey(at)cleverelephant(dot)ca> |
|---|---|
| To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: SearchSysCache() tutorial? |
| Date: | 2017-12-11 19:26:51 |
| Message-ID: | CACowWR2N-hhsd1AZPsECtkEe4GcSQojyhMSZWYMRbnhfRoZGOw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Dec 11, 2017 at 11:25 AM, Paul Ramsey <pramsey(at)cleverelephant(dot)ca> wrote:
> Is there anywhere any documentation on SearchSysCache? I find I end up
> on these long spelunking expeditions through the code base for a
> particular problem, find the answer after many hours, then forget
> everything I learned because I don't exercise my knowledge frequently
> enough. A decent reference guide would help a lot. What do the various
> SysCacheIdentifier numbers mean/search, some examples, of usage, etc,
> etc.
>
> I can accept if there are not, but it would be a shame to keep on
> hunting like this if there were a good reference lying around.
My particular hunt today is "for a given table relation, find any
indexes that use the gist access method and are on a single attribute
of type geometry".
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Melvin Davidson | 2017-12-11 19:37:37 | Re: SearchSysCache() tutorial? |
| Previous Message | Paul Ramsey | 2017-12-11 19:25:16 | SearchSysCache() tutorial? |