<transcript><audio_101>outdating because it created new versions a transaction knows right when it has added something to the version change so in this approach as a transaction proceeds it's doing an update uh and then the second operation comes in it's creating these old</transcript><transcript><audio_102>versions the basic thing is when a transaction is done it knows I created two versions one for record a one for record B and at that point a vacuum process can be handed over those versions and now</transcript><transcript><audio_103>that can determine saying my uh oldest version I need is 10 onwards if all of these are less than 10 I can go clean it up right so the vacuum process doesn't have to go through each and every page even with that dirty page marker to determine where these versions are</transcript><transcript><audio_104>transactions just hand it over to you so the and those are the things that need to get cleaned up okay so just a different way of doing that uh and clearing up the versions now this I want us to spend a little bit of time on okay</transcript><transcript><audio_105>the rest of this uh uh uh material I'll just basically leave it in slides and let you uh worry about it in other words index management is stuff up to all of this material material for exam questions but the last part I'm going to skim over and you don't need to worry</transcript> outdating because it created new versions a transaction knows right when it has added something to the version change so in this approach as a transaction proceeds it's doing an update uh and then the second operation comes in it's creating these old versions the basic thing is when a transaction is done it knows I created two versions one for record a one for record B and at that point a vacuum process can be handed over those versions and now that can determine saying my uh oldest version I need is 10 onwards if all of these are less than 10 I can go clean it up right so the vacuum process doesn't have to go through each and every page even with that dirty page marker to determine where these versions are transactions just hand it over to you so the and those are the things that need to get cleaned up okay so just a different way of doing that uh and clearing up the versions now this I want us to spend a little bit of time on okay the rest of this uh uh uh material I'll just basically leave it in slides and let you uh worry about it in other words index management is stuff up to all of this material material for exam questions but the last part I'm going to skim over and you don't need to worry
{"source": "grass-yt-cc-by.-mY8ALcJVTk|shard_1_1|create_multimodal_data.extract_yt_and_generate_transcripts.62|shard_1|create_multimodal_data.generate_captions.62|shard_1|create_multimodal_data.generate_captions.62", "params": {"id": "-mY8ALcJVTk", "channel_id": "UCHnBsf2rH-K7pn09rb3qvkA", "duration": 5000, "view_count": 4483, "age_limit": 0, "like_count": 50, "channel_follower_count": 71100, "license": "Creative Commons Attribution license (reuse allowed)", "uploader_id": "@CMUDatabaseGroup", "yt_tar_file": "/leonardo_work/EUHPC_E03_068/audio/fixed_download/grass-yt-cc-by//shard_1/-mY8ALcJVTk.tar.gz"}}