summaryrefslogtreecommitdiff
path: root/doc/src/sgml/diskusage.sgml
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2004-12-28 19:08:58 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2004-12-28 19:08:58 +0000
commit7737d01ece4823a6de70e57a35ab1c735984bd0b (patch)
treeae8db528522b75fbf58d052401ab0f9f2b8d7ac6 /doc/src/sgml/diskusage.sgml
parent31cc047d94193a98cf9753aa3181ab62f8210b7f (diff)
downloadpostgresql-7737d01ece4823a6de70e57a35ab1c735984bd0b.tar.gz
More minor updates and copy-editing.
Diffstat (limited to 'doc/src/sgml/diskusage.sgml')
-rw-r--r--doc/src/sgml/diskusage.sgml14
1 files changed, 12 insertions, 2 deletions
diff --git a/doc/src/sgml/diskusage.sgml b/doc/src/sgml/diskusage.sgml
index 215519bc27..65cc6f651f 100644
--- a/doc/src/sgml/diskusage.sgml
+++ b/doc/src/sgml/diskusage.sgml
@@ -1,5 +1,5 @@
<!--
-$PostgreSQL: pgsql/doc/src/sgml/diskusage.sgml,v 1.12 2004/12/01 19:00:27 tgl Exp $
+$PostgreSQL: pgsql/doc/src/sgml/diskusage.sgml,v 1.13 2004/12/28 19:08:58 tgl Exp $
-->
<chapter id="diskusage">
@@ -24,7 +24,10 @@ $PostgreSQL: pgsql/doc/src/sgml/diskusage.sgml,v 1.12 2004/12/01 19:00:27 tgl Ex
which is used to store values too wide to fit comfortably in the main
table. There will be one index on the
<acronym>TOAST</> table, if present. There may also be indexes associated
- with the base table.
+ with the base table. Each table and index is stored in a separate disk
+ file &mdash; possibly more than one file, if the file would exceed one
+ gigabyte. Naming conventions for these files are described in <xref
+ linkend="file-layout">.
</para>
<para>
@@ -135,6 +138,13 @@ SELECT relname, relpages FROM pg_class ORDER BY relpages DESC;
not wait until the disk is completely full to take action.
</para>
</tip>
+
+ <para>
+ If your system supports per-user disk quotas, then the database
+ will naturally be subject to whatever quota is placed on the user
+ the server runs as. Exceeding the quota will have the same bad
+ effects as running out of space entirely.
+ </para>
</sect1>
</chapter>