Postgresql 中文操作指南
29.2. Disk Full Failure #
数据库管理员最重要的磁盘监控任务是确保磁盘不会被填满。已填满的数据磁盘不会导致数据损坏，但可能会阻止有益活动的发生。如果保存 WAL 文件的磁盘被填满，可能会导致数据库服务器恐慌并进而关闭。
The most important disk monitoring task of a database administrator is to make sure the disk doesn’t become full. A filled data disk will not result in data corruption, but it might prevent useful activity from occurring. If the disk holding the WAL files grows full, database server panic and consequent shutdown might occur.
如果无法通过删除其他内容来释放磁盘上的其他空间，则可以使用表空间将某些数据库文件移动到其他文件系统中。有关更多信息，请参阅 Section 23.6。
If you cannot free up additional space on the disk by deleting other things, you can move some of the database files to other file systems by making use of tablespaces. See Section 23.6 for more information about that.
Tip
某些文件系统在几乎被填满时性能会很差，因此，请不要等到磁盘完全被填满才采取行动。
Some file systems perform badly when they are almost full, so do not wait until the disk is completely full to take action.
如果您的系统支持按用户划分的磁盘配额，那么数据库自然会受到服务器运行所用用户的任何配额的限制。超过配额将产生与完全用完磁盘空间相同的不良影响。
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 disk space entirely.