Re: System catalog documentation chapter

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(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

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