# 数据库大小与维护

**URL:** https://meta.discourse.org/t/database-size-maintenance/238312
**Category:** Self-hosting
**Created:** [2022年九月7日 07:29 UTC](https://meta.discourse.org/t/database-size-maintenance/238312 "2022-09-07T07:29:40Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![Falco](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/falco/32/179432_2.png) [@Falco](https://meta.discourse.org/u/Falco)
#### Post date: [2022年九月7日 07:55 UTC](https://meta.discourse.org/t/database-size-maintenance/238312/2 "2022-09-07T07:55:23Z")

</div>

Timings 始终是最大的表，所以这是正确的。

如果您已更新到最新版本，最后一个 PostgreSQL 版本会在此领域带来改进，但您需要遵循一个小步骤：

> [@PostgreSQL 13 update](https://meta.discourse.org/t/postgresql-13-update/172563):
>
> warning WARNING! If your database is very large, you will need a lot of extra disk space (2x database size) and should be very careful with this upgrade! We’ve just landed changes to upgrade our Docker image to PostgreSQL 13. Any site admins rebuilding Discourse from the command line will be upgraded to PostgreSQL 13 from the previous PostgreSQL 12. Note that if you held back from upgrading when the PostgreSQL 12 update [happened back in May](https://meta.discourse.org/t/postgresql-12-update/151236), you can skip that upgrade and go straight to P…

请参阅其中的“重新创建索引”。

---

_[View the full topic](https://meta.discourse.org/t/database-size-maintenance/238312)._