Zdenek Kotala wrote:
Alvaro Herrera wrote:


What's "global"?  A maybe-useful flag would be telling that a table is
shared.  Is that it?  Mind you, it's not useful to me because I know
which tables are shared, but I guess for someone not so familiar with
the catalogs it could have some use.

Global means share table stored in global directory :-). Ok I change it.


There is new version of catalogs overview patch. This version add only one column into overview table which contains Oid/Filename for each catalog table. Oid information is important if someone need make relation with filename on disk and related catalog table. In this column shared table are marked as well. Other information like bootstrap and with-oids are really useless and they is not mentioned.


        Zdenek
Index: doc/src/sgml/catalogs.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/catalogs.sgml,v
retrieving revision 2.134
diff -c -r2.134 catalogs.sgml
*** doc/src/sgml/catalogs.sgml	22 Sep 2006 23:20:13 -0000	2.134
--- doc/src/sgml/catalogs.sgml	4 Oct 2006 12:17:49 -0000
***************
*** 33,47 ****
     Most system catalogs are copied from the template database during
     database creation and are thereafter database-specific. A few
     catalogs are physically shared across all databases in a cluster;
!    these are noted in the descriptions of the individual catalogs.
    </para>
  
    <table id="catalog-table">
     <title>System Catalogs</title>
  
!    <tgroup cols="2">
      <thead>
       <row>
        <entry>Catalog Name</entry>
        <entry>Purpose</entry>
       </row>
--- 33,49 ----
     Most system catalogs are copied from the template database during
     database creation and are thereafter database-specific. A few
     catalogs are physically shared across all databases in a cluster;
!    these are noted in the Oid/Filename column and in the descriptions
!    of the individual catalogs.
    </para>
  
    <table id="catalog-table">
     <title>System Catalogs</title>
  
!    <tgroup cols="3">
      <thead>
       <row>
+       <entry>Oid/Filename</entry>
        <entry>Catalog Name</entry>
        <entry>Purpose</entry>
       </row>
***************
*** 49,214 ****
--- 51,249 ----
  
      <tbody>
       <row>
+       <entry>2600</entry>
        <entry><link linkend="catalog-pg-aggregate"><structname>pg_aggregate</structname></link></entry>
        <entry>aggregate functions</entry>
       </row>
  
       <row>
+       <entry>2601</entry>
        <entry><link linkend="catalog-pg-am"><structname>pg_am</structname></link></entry>
        <entry>index access methods</entry>
       </row>
  
       <row>
+       <entry>2602</entry>
        <entry><link linkend="catalog-pg-amop"><structname>pg_amop</structname></link></entry>
        <entry>access method operators</entry>
       </row>
  
       <row>
+       <entry>2603</entry>
        <entry><link linkend="catalog-pg-amproc"><structname>pg_amproc</structname></link></entry>
        <entry>access method support procedures</entry>
       </row>
  
       <row>
+       <entry>2604</entry>
        <entry><link linkend="catalog-pg-attrdef"><structname>pg_attrdef</structname></link></entry>
        <entry>column default values</entry>
       </row>
  
       <row>
+       <entry>1249</entry>
        <entry><link linkend="catalog-pg-attribute"><structname>pg_attribute</structname></link></entry>
        <entry>table columns (<quote>attributes</quote>)</entry>
       </row>
  
       <row>
+       <entry>1260 (shared)</entry>
        <entry><link linkend="catalog-pg-authid"><structname>pg_authid</structname></link></entry>
        <entry>authorization identifiers (roles)</entry>
       </row>
  
       <row>
+       <entry>1261 (shared)</entry>
        <entry><link linkend="catalog-pg-auth-members"><structname>pg_auth_members</structname></link></entry>
        <entry>authorization identifier membership relationships</entry>
       </row>
  
       <row>
+       <entry>1248</entry>
        <entry><link linkend="catalog-pg-autovacuum"><structname>pg_autovacuum</structname></link></entry>
        <entry>per-relation autovacuum configuration parameters</entry>
       </row>
  
       <row>
+       <entry>2605</entry>
        <entry><link linkend="catalog-pg-cast"><structname>pg_cast</structname></link></entry>
        <entry>casts (data type conversions)</entry>
       </row>
  
       <row>
+       <entry>1259</entry>
        <entry><link linkend="catalog-pg-class"><structname>pg_class</structname></link></entry>
        <entry>tables, indexes, sequences, views (<quote>relations</quote>)</entry>
       </row>
  
       <row>
+       <entry>2606</entry>
        <entry><link linkend="catalog-pg-constraint"><structname>pg_constraint</structname></link></entry>
        <entry>check constraints, unique constraints, primary key constraints, foreign key constraints</entry>
       </row>
  
       <row>
+       <entry>2607</entry>
        <entry><link linkend="catalog-pg-conversion"><structname>pg_conversion</structname></link></entry>
        <entry>encoding conversion information</entry>
       </row>
  
       <row>
+       <entry>1262 (shared)</entry>
        <entry><link linkend="catalog-pg-database"><structname>pg_database</structname></link></entry>
        <entry>databases within this database cluster</entry>
       </row>
  
       <row>
+       <entry>2608</entry>
        <entry><link linkend="catalog-pg-depend"><structname>pg_depend</structname></link></entry>
        <entry>dependencies between database objects</entry>
       </row>
  
       <row>
+       <entry>2609</entry>
        <entry><link linkend="catalog-pg-description"><structname>pg_description</structname></link></entry>
        <entry>descriptions or comments on database objects</entry>
       </row>
  
       <row>
+       <entry>2610</entry>
        <entry><link linkend="catalog-pg-index"><structname>pg_index</structname></link></entry>
        <entry>additional index information</entry>
       </row>
  
       <row>
+       <entry>2611</entry>
        <entry><link linkend="catalog-pg-inherits"><structname>pg_inherits</structname></link></entry>
        <entry>table inheritance hierarchy</entry>
       </row>
  
       <row>
+       <entry>2612</entry>
        <entry><link linkend="catalog-pg-language"><structname>pg_language</structname></link></entry>
        <entry>languages for writing functions</entry>
       </row>
  
       <row>
+       <entry>2613</entry>
        <entry><link linkend="catalog-pg-largeobject"><structname>pg_largeobject</structname></link></entry>
        <entry>large objects</entry>
       </row>
  
       <row>
+       <entry>2614</entry>
        <entry><link linkend="catalog-pg-listener"><structname>pg_listener</structname></link></entry>
        <entry>asynchronous notification support</entry>
       </row>
  
       <row>
+       <entry>2615</entry>
        <entry><link linkend="catalog-pg-namespace"><structname>pg_namespace</structname></link></entry>
        <entry>schemas</entry>
       </row>
  
       <row>
+       <entry>2616</entry>
        <entry><link linkend="catalog-pg-opclass"><structname>pg_opclass</structname></link></entry>
        <entry>index access method operator classes</entry>
       </row>
  
       <row>
+       <entry>2617</entry>
        <entry><link linkend="catalog-pg-operator"><structname>pg_operator</structname></link></entry>
        <entry>operators</entry>
       </row>
  
       <row>
+       <entry>1136 (shared)</entry>
        <entry><link linkend="catalog-pg-pltemplate"><structname>pg_pltemplate</structname></link></entry>
        <entry>template data for procedural languages</entry>
       </row>
  
       <row>
+       <entry>1255</entry>
        <entry><link linkend="catalog-pg-proc"><structname>pg_proc</structname></link></entry>
        <entry>functions and procedures</entry>
       </row>
  
       <row>
+       <entry>2618</entry>
        <entry><link linkend="catalog-pg-rewrite"><structname>pg_rewrite</structname></link></entry>
        <entry>query rewrite rules</entry>
       </row>
  
       <row>
+       <entry>1214 (shared)</entry>
        <entry><link linkend="catalog-pg-shdepend"><structname>pg_shdepend</structname></link></entry>
        <entry>dependencies on shared objects</entry>
       </row>
  
       <row>
+       <entry>2396 (shared)</entry>
        <entry><link linkend="catalog-pg-shdescription"><structname>pg_shdescription</structname></link></entry>
        <entry>comments on shared objects</entry>
       </row>
  
       <row>
+       <entry>2619</entry>
        <entry><link linkend="catalog-pg-statistic"><structname>pg_statistic</structname></link></entry>
        <entry>planner statistics</entry>
       </row>
  
       <row>
+       <entry>1213 (shared)</entry>
        <entry><link linkend="catalog-pg-tablespace"><structname>pg_tablespace</structname></link></entry>
        <entry>tablespaces within this database cluster</entry>
       </row>
  
       <row>
+       <entry>2620</entry>
        <entry><link linkend="catalog-pg-trigger"><structname>pg_trigger</structname></link></entry>
        <entry>triggers</entry>
       </row>
  
       <row>
+       <entry>1247</entry>
        <entry><link linkend="catalog-pg-type"><structname>pg_type</structname></link></entry>
        <entry>data types</entry>
       </row>
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to