In Postgres land bloat refers to dead tuples that are left in place during certain operations and need to be vacuumed later.
It’s challenging to write a queue that doesn’t create bloat, hence why this project is citing it as a feature.
It’s challenging to write a queue that doesn’t create bloat, hence why this project is citing it as a feature.
Your temporal partition idea is spot on. But instead of dropping old partitions, you can instead archive them.