kuroyi

5 ms·

1. 1.▲
   by kuroyi 11y ago

   My tables are partitioned daily and I still have had issues. The problem is they all still need vacuumed but at least the individual table vacuums are shorter and it makes it easier to drop older data.
2. 2.▲
   by kuroyi 11y ago

   Essentially a large volume of sensor data. Tons of inserts. Some updates in other tables.
3. 3.▲
   by kuroyi 11y ago

   Reducing the autovacuum_vacuum_cost_delay seems to have helped in my case. The autovacuums just run too slow.
4. 4.▲
   by kuroyi 11y ago

   I hit this issue all the time and it is never easy or fast to fix once postgres stops accepting writes. If you have a write heavy postgres database, the autovacuum settings are not sufficient. The entire database needs to be vacuumed aggres