# Perché il mio discourse postgres\_data è troppo grande

**URL:** <https://meta.discourse.org/t/why-my-discourse-postgres-data-is-too-big/91657>\
**Category:** Self-hosting\
**Created:** [5 Luglio 2018, 8:54pm UTC](https://meta.discourse.org/t/why-my-discourse-postgres-data-is-too-big/91657 "2018-07-05T20:54:31Z")\
**Posts on this page:** 1\
**Showing post:** 13

<div class="post-metadata">

**Author:** ![tgxworld](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/tgxworld/32/106117_2.png) [@tgxworld](https://meta.discourse.org/u/tgxworld)\
**Post date:** [7 Luglio 2018, 1:01am UTC](https://meta.discourse.org/t/why-my-discourse-postgres-data-is-too-big/91657/13 "2018-07-07T01:01:23Z")

</div>

```plaintext
backup.topic_views

```

I looks like you did a restore recently and the data before the restore is backup-ed in the `backup` schema. If you’re certain that you no longer need to recover back to the previous state, you can drop the schema by running the following commands.

```plaintext
./launcher enter app
su - postgres
psql discourse
ALTER SCHEMA "backup" TO "backup-moved";
# Check that you site is still working and up to date
DROP SCHEMA "backup-moved" CASCADE;

```

---

_[View the full topic](https://meta.discourse.org/t/why-my-discourse-postgres-data-is-too-big/91657)._