Hello,
I have several questions regarding the use of postgres.
The database is used for zabbix supervision application. It is heavily loaded (1500 values per second).
I can not get the vacuum daily analyse, process vacuum goes into Waiting mode.
Is it possible to make tuning to force the vacuum analyse to pass?
Or do I do app down?
su - postgres -c "vacuumdb -z -e -v -d zabbix"
Thank you in advance.
Nicolas Aubert