# Clean up (or validate) Postgres data?

**URL:** <https://meta.discourse.org/t/clean-up-or-validate-postgres-data/168668>\
**Category:** Self-hosting\
**Created:** [October 29, 2020, 6:16pm UTC](https://meta.discourse.org/t/clean-up-or-validate-postgres-data/168668 "2020-10-29T18:16:09Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![wincenworks](https://avatars.discourse-cdn.com/v4/letter/w/96bed5/32.png) [@wincenworks](https://meta.discourse.org/u/wincenworks)\
**Post date:** [November 1, 2020, 12:41am UTC](https://meta.discourse.org/t/clean-up-or-validate-postgres-data/168668/3 "2020-11-01T00:41:54Z")

</div>

I’ve done a few launcher cleanups, they don’t seem to effect the postgres database size.

The full vacuum seems to have shaved 5 gig off my postgres data.

While trying to do a full vacuum I received this error (shown here after I did it again in verbose):

 ![image](https://global.discourse-cdn.com/meta/original/3X/f/b/fbe2f66ad391fe26a98a83d9c0e39172516e22bb.png)

I also tried doing a reindex and received this error:

 ![image](https://global.discourse-cdn.com/meta/original/3X/4/1/4154b6ce0e82176c3d62cfc197f9bde70f42a342.png)

Is there anything I can/should do about these or just reattempt rebuilding/upgrading?

---

_[View the full topic](https://meta.discourse.org/t/clean-up-or-validate-postgres-data/168668)._
