What housekeeping is performed on the database in the Mendix cloud?

2
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.
asked
2 answers
1

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).

answered
0

Hi Nikel

running "select name, setting from pg_settings where name = 'autovacuum'"' with com.mendix.core.DataStorage()'s connection obj on the Mendix cloud boxes reveals

name,setting
autovacuum,on

last_autovacuum field is filled

relname,last_vacuum,last_autovacuum,last_analyze,last_autoanalyze
foo$bar,null,null,2019-07-08 09:19:20.383822+00,null

What is your experience?

answered