What housekeeping is performed on the database in the Mendix cloud?
Does anyone know what housekeeping is performed on the database in the Mendix cloud? And is this different for different cloud environment versions? When I run the query “select relname, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze from pg_stat_user_tables;” I notice that most tables have never been vacuum'd or analyze'd ever at all. This also aligns with my observation that some queries speed up immensely after performing a “VACUUM ANALYZE” myself. Sadly, as long as we are on Mendix 6, I cannot fix this behaviour as I canont access the database directly.
I don’t think that this is documented but you could ask Mendix support. I think that more people are interested in it (I am).
running "select name, setting from pg_settings where name = 'autovacuum'"' with com.mendix.core.DataStorage()'s connection obj on the Mendix cloud boxes reveals