AnsweredAssumed Answered

Compacting Postgresql database size

Question asked by villdre on Jan 31, 2017
Latest reply on Mar 1, 2018 by gomezma

Hi All

 

We are running Alfresco CE 5.1 and Postgresql 9.4 on a separate server. When I take a dump of the database for backup, the SQL file generated is more than 20GB in size. This seems a bit large given the number of users and number of documents that we have (we do have a few tenants created).

 

Any ideas where to start to check if this size can be reduced / optimized?

 

Thanks

Vipul

Outcomes