All true. The way the VACUUM truncation works confuses people sometimes. The database has to exclusive lock the very last page of the table to shrink the file. It does that over and over again, until it finds a page that's still live.
VACUUM can truncate empty pages at the end of a table but doesn't do the same for indexes.
Yes, an access-exclusive lock is needed for truncation. Since some users may prefer to avoid this, I implemented the "vacuum_truncate" storage parameter, allowing them to choose whether truncation should occur.
United States เทรนด์
- 1. Rob Reiner 328K posts
- 2. Good Monday 42.7K posts
- 3. #MondayMotivation 8,283 posts
- 4. All in the Family 31.3K posts
- 5. Meathead 9,665 posts
- 6. Victory Monday 1,074 posts
- 7. Stand By Me 27.5K posts
- 8. The Princess Bride 22.7K posts
- 9. #MondayMood N/A
- 10. When Harry Met Sally 27.4K posts
- 11. #MondayVibes 3,007 posts
- 12. Ella Cook 35.4K posts
- 13. Spinal Tap 21.5K posts
- 14. Chile 837K posts
- 15. Shaq 6,112 posts
- 16. Brentwood 23.2K posts
- 17. Derry 84.9K posts
- 18. Kast 636K posts
- 19. Archie Bunker N/A
- 20. taeyong 158K posts
Loading...
Something went wrong.
Something went wrong.