list table quadruples when upgrading labkey from v17 to v19.1 | Jon (LabKey DevOps) | 2020-10-29 10:24 |
Status: Closed | ||
Hi Qing, Ideally, it would be preferred to get the labkey.log and other labkey.log files (such as labkey.log.1) that contains the logs that corresponds with the upgrade that took place. That said, did you by chance do any kind of database maintenance? Specifically running a VACUUM on your PostgreSQL database to have it reclaim space? https://www.postgresql.org/docs/current/sql-vacuum.html Often times, much of that database bloat on tables are due to having various deleted objects that aren't fully deleted since it requires the VACUUM to be ran. Although some people enable the AUTOVACUUM feature, it doesn't always get turned on properly. If you haven't ran a VACUUM on your database, give that a try and then recheck your table size again. Keep in mind that a VACUUM can lock tables or the whole database, so it's recommended to do this during off-hours when the server isn't in use. Regards, Jon |
||