Do we have any recommendations to run full vacuum online to remove the

Sandy Rathod

Do we have any recommendations to run full vacuum online to remove the tupples. I know full vacuum is offline activity trying to achieve the system without downtime PG repack is one of addon I see any better way of achieving this

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar5y ago
Accepted answer
Sure. The extension is implemented as a background-worker process (a framework introduced in version 9.4) that periodically monitors user-defined tables. When it detects that a table has exceeded the “bloat threshold”, it kicks in and rebuilds that table automatically. Rebuilding happens concurrently in the background with minimal storage and computational overhead due to the use of Postgres’ built-in replication slots together with logical decoding to extract possible table changes happening during the rebuild from XLOG.

search: pg_squeeze: fixing bloated tables - CYBERTEC - PostgreSQL
+2
Sandy Rathod5y ago
Thank you, I will check this out
+1
Sandy Rathod5y ago
Thanks can that do the full vacuum without need for downtime
+1
Rajanikant Hawaldar5y ago
Try pg_squeeze
+1