Question : I’m looking into issues with our autovacuum settings and trying to understand last_autoanalyze and last_autovacuum from the pg_stat_all_tables. […]
Tag: autovacuum
Are autovacuum VACUUMs slower than a manual VACUUM?
Question : I have a few large tables that take days to autovacuum, sometimes resulting in poor performance until the […]
Zabbix partitioning autovacuum causes locking
Question : I have a Zabbix database on a postgresql backend that grew to ~1TB of disk space. The Zabbix […]
What version of PostgreSQL first implemented autovacuum?
Question : I’m just wondering what version of PostgreSQL first implemented autovacuum. Answer : Prior to PostgreSQL 8.1 it was […]
PostgreSQL ERROR: cannot freeze committed xmax
Question : First of all, I am new to PostgreSQL database. In my PostgreSQL log I can see errors bellow […]
PostgreSQL with PostGIS – autovacuum for raster table
Question : I have PostGIS enabled and use raster data in the table. This table has over 2 million rows […]
setup table level Autovacuuming on postgres database
Question : I am trying to setup table level Autovacuuming on postgres database. What all metrices I need to collect […]
Postgres Performance degradation
Question : I have a Postgres 9.6 database and after some time (15 h), database performance starts to decrease dramatically, […]
Do postgres autovacuum properties persist for DB replications?
Question : I would like to understand postgres replication options more, and as I am doing my research, I have […]
Do postgres autovacuum properties persist for DB replications?
Question : I would like to understand postgres replication options more, and as I am doing my research, I have […]