11/15/2023 0 Comments Change dead space languageInstead, it creates a new version of that row (a new tuple) and marks the old one as dead. Similarly, when you UPDATE a row, Postgres doesn't modify the existing tuple.If these dead tuples can accumulate and got deleted by vacuuming in large volumes, this leads to table and index bloat. Instead, the old tuple gets marked as dead but stays around untill VACUUM deletes it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |