Re: [HACKERS] Empty system tables - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Empty system tables
Date
Msg-id 5484.927299222@sss.pgh.pa.us
Whole thread Raw
In response to Empty system tables  ("D'Arcy" "J.M." Cain <darcy@druid.net>)
List pgsql-hackers
darcy@druid.net ("D'Arcy" "J.M." Cain) writes:
> perhaps we can update the docs to describe them.

>   pg_listener

pg_listener records which backends are actively listening for NOTIFY
conditions, and is used to transmit NOTIFY signals from one backend to
another.  It will be empty if you do not have any active LISTEN
commands.

>   pg_shadow

Shadow user table, with the real passwords.  (pg_user is actually
only a view of pg_shadow.)

>   pg_statistic

Per-column stats collected by VACUUM ANALYZE and used by the query
optimizer.

Dunno about the rest.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Numeric and Aggregate: transform node 107
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Broken select on regular expression !!!