I worked with Timescale again to write an article on how table bloat effects large tables, and how we can fix it.
We cover a range of topics including:
- What is table bloat?
- Why is it an issue?
- How to monitor table bloat?
- What Vacuum and AutoVacuum is
- Tips with tuning AutoVacuum
- Table Partitioning
- How Timescale chunks makes partitioning easier
- And more!