Re: SearchSysCache() tutorial? - Mailing list pgsql-general

From Paul Ramsey
Subject Re: SearchSysCache() tutorial?
Date
Msg-id CACowWR2N-hhsd1AZPsECtkEe4GcSQojyhMSZWYMRbnhfRoZGOw@mail.gmail.com
Whole thread Raw
In response to SearchSysCache() tutorial?  (Paul Ramsey <pramsey@cleverelephant.ca>)
Responses Re: SearchSysCache() tutorial?
Re: SearchSysCache() tutorial?
List pgsql-general
On Mon, Dec 11, 2017 at 11:25 AM, Paul Ramsey <pramsey@cleverelephant.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".


pgsql-general by date:

Previous
From: Paul Ramsey
Date:
Subject: SearchSysCache() tutorial?
Next
From: Melvin Davidson
Date:
Subject: Re: SearchSysCache() tutorial?