Check out my udemy Introduction to Database Engineering course database.husseinnasser.com Learn the fundamentals of database systems to understand and build performant backend apps
'vacuum full' command will actually lock the the rows on a given page and prevent read writes because it will copy the entire page contents and create a separate page and put them there. This way the freed up space can be reclaimed by the system. That's why it's important to not run 'vacuum full' on production tables if you don't want any downtime
Maybe you could discuss about in which application types or scenarios you prefer postgres over mysql/mariadb and vice-versa. I'm learning a lot from your videos, by the way!
Hahaha, I'm just curious to know if you stepped out to make a video or created a video when u came for a daily walk. But jokes aside, the video was informative.
I don’t really have a favorite. I am used to Postgres and I like it but I also like some of the design decisions mySQL/MariaDB make with database engines
Hi Hussein! Thanks for the great talk and content :) Can you provide me with an invite for your discord server as all the invites in the previous videos have expired?
Check out my udemy Introduction to Database Engineering course
database.husseinnasser.com
Learn the fundamentals of database systems to understand and build performant backend apps
'vacuum full' command will actually lock the the rows on a given page and prevent read writes because it will copy the entire page contents and create a separate page and put them there. This way the freed up space can be reclaimed by the system. That's why it's important to not run 'vacuum full' on production tables if you don't want any downtime
I could not notice you just walked in a circle on that street 😅. Nice info btw!
Maybe you could discuss about in which application types or scenarios you prefer postgres over mysql/mariadb and vice-versa. I'm learning a lot from your videos, by the way!
Which algorithms are most important in learning the internals of a database like mysql/postgresql?
Hello, could you recommend some books to read? Talking about software development in general. Great video btw!
After vacuum deletes those 50M old tuples, you are left with mostly empty pages. Does having such pages slow down select queries?
Hi Hussein,
Please Can you do a video, on Reconciliation system for Fintechs.
Hahaha, I'm just curious to know if you stepped out to make a video or created a video when u came for a daily walk.
But jokes aside, the video was informative.
It would be intresting if you can do youtube on bitcoin in depth as backend point of view...🙏
yes
Here's the rundown: you're being conned by those who promote crypto
@@squirrel1620 very accurate
Which country do you live in?) Thanks!
Hey, which is your fav db & why?🤔
I don’t really have a favorite. I am used to Postgres and I like it but I also like some of the design decisions mySQL/MariaDB make with database engines
Hi @@hnasr , amongst NoSQL?
Any MSSQL?
hi
first
Hi Hussein! Thanks for the great talk and content :)
Can you provide me with an invite for your discord server as all the invites in the previous videos have expired?