Configure database settings—ArcGIS Monitor | Documentation
in the doc link above see "Configure data retention policies".
You still need to perform regular maintenance for the PostgreSQL database, see example below, I execute this every Sunday.
-----------------------------------
set hh=%time:~0,2%
set stamp=%date:~4,2%-%date:~7,2%-%date:~12,2%_%hh%%time:~3,2%%time:~6,2%
set stamp=%stamp: =%
echo Begin: %stamp%
SET PGDIR="C:\Program Files\PostgreSQL\14\bin"
SET PGPASSWORD=*****
%PGDIR%\psql --version
echo Vaccum: %date% %time%
%PGDIR%\psql -p 5434 -U postgres -w -d agmon1 -c "vacuum"
echo Reindex: %date% %time%
%PGDIR%\psql -p 5434 -U postgres -w -d agmon1 -c "reindex database topo1"
echo Analyze: %date% %time%
%PGDIR%\psql -p 5434 -U postgres -w -d agmon1 -c "analyze"
-----------------------------------
| Marcelo Marques | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov