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 Xu hướng
- 1. Rob Reiner 341K posts
- 2. Good Monday 45.1K posts
- 3. #MondayMotivation 8,659 posts
- 4. Victory Monday 1,209 posts
- 5. All in the Family 32.1K posts
- 6. Meathead 10.1K posts
- 7. Stand By Me 28.8K posts
- 8. #MondayVibes 3,184 posts
- 9. The Princess Bride 23.5K posts
- 10. When Harry Met Sally 28.6K posts
- 11. #MondayMood 1,016 posts
- 12. Ella Cook 37K posts
- 13. Spinal Tap 22.1K posts
- 14. Chile 852K posts
- 15. Shaq 6,306 posts
- 16. Brentwood 23.6K posts
- 17. Derry 86.9K posts
- 18. iRobot 12.7K posts
- 19. Simone 11.6K posts
- 20. James Woods 13.8K posts
Loading...
Something went wrong.
Something went wrong.