Re: System catalog documentation chapter - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: System catalog documentation chapter
Date
Msg-id YtlZInw+7R9wDR4e@momjian.us
Whole thread Raw
In response to Re: System catalog documentation chapter  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On Wed, Jul 20, 2022 at 09:19:17PM -0400, Bruce Momjian wrote:
> On Wed, Jul 20, 2022 at 04:32:46PM -0400, Bruce Momjian wrote:
> > On Wed, Jul 20, 2022 at 04:23:21PM -0400, Isaac Morland wrote:
> > > Will there be a comprehensive list somewhere? Even if it just lists the views,
> > > gives maybe a one-sentence description, and links to the relevant chapter, I
> > > would find that helpful sometimes.
> > 
> > I was not planning on that since we don't do that in any other cases I
> > can think of.
> > 
> > > I ask because I occasionally find myself wanting a comprehensive list of
> > > functions, and as far as I can tell it doesn't exist. I'm hoping to avoid that
> > > situation for views.
> > 
> > Well, then we just leave them where the are and link to them from other
> > parts of the documentation, which I assume/hope we already do.
> 
> People have mentioned the view documentation doesn't belong in the
> Internals part.  Maybe we can just move it to the Server
> Administration part and leave it together.

Thinking some more about this, I wonder if we should distinguish system
views that are needed for a task vs those used for reporting.  For
example, pg_stat_activity is a dymamic view and is needed for
monitoring.  pg_prepared_statements just reports the prepared
statements.

Could it be that over time, we have moved the "needed for a task" views
into the relevant sections, and the reporting views have just stayed as
a group, and that is okay --- maybe they just need to be moved to Server
Administration?

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Indecision is a decision.  Inaction is an action.  Mark Batterson




pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: [PATCH v1] eliminate duplicate code in table.c
Next
From: Aleksander Alekseev
Date:
Subject: Re: [PATCH v1] eliminate duplicate code in table.c