Re: SearchSysCache() tutorial?

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: Raw Message | Whole Thread | 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".

In response to

Responses

Browse pgsql-general by date

  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?