I’m currently trying to upgrade from DHIS2 2.31.5 (CI build) to DHIS2 2.32.1 (CI build) and can see that the Flyway migration seems to be taking an excessive amount of time and quite a lot of disk space.
The original database was around 20GB, it runs for over an hour, slowly taking up more and more space, until it finally uses up the 100GB of disk space and crashes.
I’ve set max_locks_per_transaction to 1024 and the PostGIS extension is installed. The DB is running Postgresql 11 (on an AWS RDS instance with 4GB RAM). From the postgres logs, I see a whole bunch of buffer write outs every few minutes when it gets to 1.2GB.
Any thoughts on what might be happening?