Why I still see delta history if I made a vacuum with just 5 hours retention

chevichenk
New Contributor III

Hi, everyone!

I execute a vacuum with 5 hours retention but I can see all the history of versions, even I can query those older version of the table.

Plus, when I see the history version, it doesn't start with zero (supposed to be the creation of the table), so, if making vacuum with few hours of retention doesn't clear the history version, how can this happen? ‌‌🤔

Before vacuum, oldest version starts in 30 and ends in 83

chevichenk_1-1699661687787.png

After vacuum, oldest version starts in 30 and ends in 85 (start and end vacuum) version zero must be the creation of the table

 

Thanks for your attention! 🙂