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. #Survivor49 13.6K posts
- 2. Disturbed 6,485 posts
- 3. #PresidentialAddress 14.9K posts
- 4. Savannah 16.9K posts
- 5. Newt 2,142 posts
- 6. Cartoon Network 1,579 posts
- 7. Kristina 4,421 posts
- 8. Garfunkel N/A
- 9. IT MATTERS 47.8K posts
- 10. Jake Allen N/A
- 11. Rizo 2,150 posts
- 12. #AEWDynamite 23.3K posts
- 13. Warrior Dividend 28.3K posts
- 14. Cavs 7,609 posts
- 15. Jimmy Fallon 5,811 posts
- 16. #SistasOnBET 2,550 posts
- 17. Adderall 5,572 posts
- 18. Billie Eilish 11K posts
- 19. Bernie Mac N/A
- 20. Sophi 2,114 posts
Loading...
Something went wrong.
Something went wrong.