Question : I have PostGIS enabled and use raster data in the table. This table has over 2 million rows […]
Tag: autovacuum
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 […]
When will autovacuum work in PostgreSQL?
Question : I tested the autovacuum in PostgreSQL. So I create a table company and insert 100 records. Then I […]
PostgreSQL vacuum starting too late (every 100k instead of 10k dead rows)
Question : I have a large table (50M) and autovacuum seems to work properly in general. However I started monitoring […]
Automatic vacuum fails with `ERROR: XX000: cache lookup failed for type 0`
Question : I’ve been noticing something like this popping up every 15 seconds in my server logs: 2020-01-30 21:10:30 UTC::@:[24969]:ERROR: […]
PostgreSQL 9.6.12 autovacuum constantly running on system tables
Question : I come from a SQL Server, Oracle, Sybase DBA background but I am now looking into an AWS […]
Postgres – autovacuum on several big tables
Question : I have an issue with autovacuum – I have several big tables (over 10 million records) which are […]