There is common misconception that troubles most developers using PostgreSQL: tune VACUUM or run VACUUM, and your database will stay healthy. Dead tuples will get cleaned up. Transaction IDs recycled. Space reclaimed. Your database will live happily ever after.
But there are couple of dirty “secrets” people are not aware of. First of them being VACUUM is lying to you about your indexes.
Click through to learn more.