Postgresql 中文操作指南
14.5. Non-Durable Settings #
耐久性是一项数据库功能,即使服务器崩溃或断电,也能保证已提交事务的记录。但是,耐久性会显著增加数据库的开销,因此如果您的站点不需要这样的保证,PostgreSQL 就可以配置为运行得更快。以下是您可以在这种情况下进行的配置更改,以提高性能。除非下面有注明,否则在数据库软件崩溃时仍能保证耐久性;只有操作系统突然崩溃时会在使用这些设置时造成数据丢失或损坏的风险。
Durability is a database feature that guarantees the recording of committed transactions even if the server crashes or loses power. However, durability adds significant database overhead, so if your site does not require such a guarantee, PostgreSQL can be configured to run much faster. The following are configuration changes you can make to improve performance in such cases. Except as noted below, durability is still guaranteed in case of a crash of the database software; only an abrupt operating system crash creates a risk of data loss or corruption when these settings are used.