Re: Order of views in stats docs

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Order of views in stats docs
Date: 2014-11-09 14:46:54
Message-ID: CABUevEwpvRuwPdmj_nZa3Yz9KH__GM4PLTZ1+JjMiSMbNW9AUA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Nov 6, 2014 at 3:01 PM, Peter Eisentraut <peter_e(at)gmx(dot)net> wrote:
> On 11/6/14 6:16 AM, Magnus Hagander wrote:
>> Another thought I had in that case is maybe we need to break out the
>> pg_stat_activity and pg_stat_replication views into their own table.
>> They are really the only two views that are different in a lot of
>> ways. Maybe call the splits "session statistics views" and "object
>> statistics views", instead of just "standard statistics views"? The
>> difference being that they show snapshots of *right now*, whereas all
>> the other views show accumulated statistics over time.
>
> Yeah, splitting this up a bit would help, too.

Here's an initial run of this. It still feels wrong that we have the
dynamic views under "the statistics collector". Perhaps longterm we
should look at actually splitting them out to a completely different
sect1?

I only fixed the obvious parts in this - the split out, and the moving
of pg_stat_database_conflicts. But it's a first step at least.

Objections?

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/

Attachment Content-Type Size
stats_tables_reorg.patch text/x-patch 19.7 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Steve Singer 2014-11-09 16:57:53 Re: tracking commit timestamps
Previous Message Fujii Masao 2014-11-09 13:32:21 Re: [REVIEW] Re: Compression of full-page-writes