Question : Situation PostgreSQL v11 I have a database with a dozen tables. No rows are ever DELETEd or UPDATEd. […]
Tag: vacuum
Aggressive Autovacuum on PostgreSQL
Question : I’m trying to get PostgreSQL to aggressively auto vacuum my database. I’ve currently configured auto vacuum as follows: […]
PostgreSQL – VACUUM speed (Heroku)
Question : My DB have a main table that is has lots of commits on a daily basis, with about […]
Keeping postgres connection behind load balancer alive during long-running query (vacuum)
Question : Background: I have a postgres instance behind a load balancer (AWS Classic Load Balancer). I want to access […]
How to view the current settings of Autovacuum in Postgres?
Question : I’ve found a million examples of how to set Autovacuum’s configuration settings, but can’t seem to find how […]
Postgres Vacuum in Function
Question : After googleing a bit, it’s plainly clear you cannot run vacuum from a function: Postgres mailing – Vacuum […]
Postgresql Vacuum and replication
Question : I have an architecture of cascading replication with 3 postgresql db Because the master is becoming too big […]
What fillfactor for caching table?
Question : I have heavily updated / accessed table where I store serialized java objects. They are in the table […]
Autovacuum is not running or working
Question : We’re currently using Postgres 9.4.14 hosting Zabbix 2.4 database. For a while now, the following message started to […]
Busy table is not getting vacuumed
Question : We’re using Postgres 9.2 on Windows to store low-frequency timeseries data: we’re inserting around 2000 rows per second […]