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 Tren
- 1. Vanity Fair 38.9K posts
- 2. Susie Wiles 87.1K posts
- 3. Mick Foley 27.1K posts
- 4. Raphinha 48.1K posts
- 5. Disclosure Day 17.4K posts
- 6. Michelea Ponce 14.5K posts
- 7. Spielberg 23.8K posts
- 8. Brad Johnson N/A
- 9. Alan Jackson N/A
- 10. My Fellow Americans 3,046 posts
- 11. Palmer 41K posts
- 12. Larian 7,345 posts
- 13. langdon 2,770 posts
- 14. Unemployment 59.9K posts
- 15. Philo 2,178 posts
- 16. Doug Williams N/A
- 17. Bellingham 30.2K posts
- 18. Josh Freeman N/A
- 19. CSC Academic All-District N/A
- 20. Emily Blunt 5,979 posts
Loading...
Something went wrong.
Something went wrong.