diff options
Diffstat (limited to 'doc/src/sgml/diskusage.sgml')
| -rw-r--r-- | doc/src/sgml/diskusage.sgml | 20 |
1 files changed, 11 insertions, 9 deletions
diff --git a/doc/src/sgml/diskusage.sgml b/doc/src/sgml/diskusage.sgml index 6bec4e20b4a..3749c315ab9 100644 --- a/doc/src/sgml/diskusage.sgml +++ b/doc/src/sgml/diskusage.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/diskusage.sgml,v 1.1 2002/06/13 05:15:22 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/diskusage.sgml,v 1.2 2002/06/21 19:06:44 momjian Exp $ --> <chapter id="diskusage"> @@ -22,10 +22,12 @@ $Header: /cvsroot/pgsql/doc/src/sgml/diskusage.sgml,v 1.1 2002/06/13 05:15:22 mo </para> <para> - You can monitor disk space from two places; from inside - <application>psql</> and from the command line using - <application>contrib/oid2name</>. Using <application>psql</> you can - issue queries to see the disk usage for any table: + You can monitor disk space from three places: from + <application>psql</> using <command>VACUUM</> information, from + <application>psql</> using <application>contrib/dbsize</>, and from + the command line using <application>contrib/oid2name</>. Using + <application>psql</> on a recently vacuumed (or analyzed) database, + you can issue queries to see the disk usage of any table: <programlisting> play=# SELECT relfilenode, relpages play-# FROM pg_class @@ -38,10 +40,10 @@ play-# WHERE relname = 'customer'; </para> <para> - Each page is typically 8 kilobytes. <literal>relpages</> is only - updated by <command>VACUUM</> and <command>ANALYZE</>. To show the - space used by <acronym>TOAST</> tables, use a query based on the heap - relfilenode: + Each page is typically 8 kilobytes. (Remember, <literal>relpages</> + is only updated by <command>VACUUM</> and <command>ANALYZE</>.) To + show the space used by <acronym>TOAST</> tables, use a query based on + the heap relfilenode shown above: <programlisting> play=# SELECT relname, relpages play-# FROM pg_class |