Re: PostgreSQL DB checkpoint error!

> On Apr 28, 2020, at 2:31 AM, Ashok kumar Mani <amani(at)accelaero(dot)com> wrote:
>
> I am running cronjob at the same time which will do data pruning for zabbix database(psql). Please let me know if that warning is related to reindex and vacuum ?
>
> ^C-bash-4.2$ cat /Data/zabbix_hkp/scripts/data_Pruning.sh
> psql -d zabbix -f /Data/zabbix_hkp/scripts/three_months_datapurge.sql 1>/Data/zabbix_hkp/scripts_log/data_purging_`date +%m%d%y`.log 2>data_cleaning_err_`date +%m%d%y`.log
> -bash-4.2$ cat /Data/zabbix_hkp/scripts/three_months_datapurge.sql
> -- Delete alerts which are older than 1 day -> tested on 8th april 2020
> delete FROM alerts where age(to_timestamp(alerts.clock)) > interval '90 days';
> VACUUM FULL alerts ;
> REINDEX TABLE ALERTS;
> delete FROM acknowledges where age(to_timestamp(acknowledges.clock)) > interval '90 days';
> VACUUM FULL acknowledges;
> REINDEX TABLE acknowledges;

I would say so; the vacuum full and reindex is going create blocking situations that will hang Zabbix. I wouldn’t run vacuum full or reindex.