One of the big value I get from your videos, especially this kind of video is the vocabulary around the topic (aka the domain model), and the fact it fleshes out or enriches one intuition; which helps us find a solutions quicker, when you face a narrow issues.
Wow, there are so many fundamental and deep concepts in your video that I feel dumb not to have known most of them, despite working with Postgres for years. Thank you so much.
Might I suggest that you use some kind of pointer ( mouse cursor ) to point to the items in the presentation as you speak. It would really further improve your presentation. Because as viewers, it is sometimes difficult to predict where exactly focus / intention is. As always, your videos are extremely helpful, thank you so much.
Maybe, but it's fine to me and helps me be more engaged, Also additionally Naseer can flow his thoughts as usual without having to bother about pointers.
Thanks, I wanted to know more about Postgres and in the end I got much more knowledge about Architecture from it which is much more valuable. Your first video that I watch and I immediately subscribed
Great summary. An improvement I can suggest would be to expand the acronym WAL (Write-Ahead Logging). I had to look that up elsewhere. I guess you could do a whole webcast on it & how it works.
Thank you Hussein! Love your content, from all the tech TH-camrs, i can follow you the best, hope you doing good in life! As soon as I found my place in tech, I will donate to you. Keep up the great work!
Great info... I always guess what was the 'real' difference and strengths between PostGRE and MySQL/MariaDB... now please do the same for MariaDB... and for MS-SQL... and in the end a comparative of use cases and why....
On your point about there being lot of TLB cache misses due to Postgres having processes instead of Threads, this is not really the case - There is one TLB per core for most modern processors (Intel - core/AMD - ryzen) and all processes on that core can share that TLB, so there will be no TLB miss due to postgres having multiple processes. Different core processes will face TLB miss but that is true for Threads as well. There is one TLB per process in different processors such as ARM processors used in mobiles where the use case support this as every app's TLB entries are flushed after that app is killed.
By default, Django creates a new database connection for each user request, resulting in a separate PostgreSQL process being spun up for each connection. Essentially, Django acts as a client to the PostgreSQL backend. Does this approach effectively scale for a web application?
@hnasr Could you do a comparaison with GCP AlloyDB ? To understand the difference and the architectural changes that GCP decided to apply to PG, especially the decoupling of compute from storage. I just don't know if there is enough information out there.
It's crazy how fork is still the standard mechanism to spawn new processes. It's unnecessarily expensive even with the optimizations and has thread safety issues, plus it's horrible from API perspective. We should use alternatives like posix_spawn for better efficiency, less bugs and easier to use code.
The number of adverts on this video is crazy. Constant interruptions make it harder for me to absorb the information in the video. Only got half way through then gave up.
Learn the fundamentals of database engineering database.husseinnasser.com
One of the big value I get from your videos, especially this kind of video is the vocabulary around the topic (aka the domain model), and the fact it fleshes out or enriches one intuition; which helps us find a solutions quicker, when you face a narrow issues.
Wow, there are so many fundamental and deep concepts in your video that I feel dumb not to have known most of them, despite working with Postgres for years. Thank you so much.
No one is dumb bro.. its just you have not gone through that side. Keep learning keep growing.
Might I suggest that you use some kind of pointer ( mouse cursor ) to point to the items in the presentation as you speak. It would really further improve your presentation. Because as viewers, it is sometimes difficult to predict where exactly focus / intention is. As always, your videos are extremely helpful, thank you so much.
Maybe, but it's fine to me and helps me be more engaged, Also additionally Naseer can flow his thoughts as usual without having to bother about pointers.
Just noticed that you explain much more details in your articles than videos, switching back and forth between video and article 🤓
One the amazing part which I really love about postgres is its Indexing
Thanks, I wanted to know more about Postgres and in the end I got much more knowledge about Architecture from it which is much more valuable.
Your first video that I watch and I immediately subscribed
Excellent stuff !! A great salute to you !!
These are some high quality and high value videos, absolutely love these videos.
Thanks
Great summary. An improvement I can suggest would be to expand the acronym WAL (Write-Ahead Logging). I had to look that up elsewhere. I guess you could do a whole webcast on it & how it works.
Thank you Hussein! Love your content, from all the tech TH-camrs, i can follow you the best, hope you doing good in life!
As soon as I found my place in tech, I will donate to you. Keep up the great work!
1st time I heard "I wanna spend some time to talk about oscarous architecture" 🏆😅🏆Great work man btw. Thanks!
still works perfectly . BLESS YOU KIND STRANGER, THANK YOU!
Great info... I always guess what was the 'real' difference and strengths between PostGRE and MySQL/MariaDB...
now please do the same for MariaDB... and for MS-SQL... and in the end a comparative of use cases and why....
Thank you - super helpful!
love to support a budding artist, keep it up
On your point about there being lot of TLB cache misses due to Postgres having processes instead of Threads, this is not really the case - There is one TLB per core for most modern processors (Intel - core/AMD - ryzen) and all processes on that core can share that TLB, so there will be no TLB miss due to postgres having multiple processes. Different core processes will face TLB miss but that is true for Threads as well. There is one TLB per process in different processors such as ARM processors used in mobiles where the use case support this as every app's TLB entries are flushed after that app is killed.
great video. thanks so much for your time making this.
Great video, thanks
Please do MySql architecture video too.
Great video!
By default, Django creates a new database connection for each user request, resulting in a separate PostgreSQL process being spun up for each connection. Essentially, Django acts as a client to the PostgreSQL backend. Does this approach effectively scale for a web application?
Great stuff as always, your efforts are much appreciated! ❤
One word:
A W E S O M E !
@hnasr Could you do a comparaison with GCP AlloyDB ? To understand the difference and the architectural changes that GCP decided to apply to PG, especially the decoupling of compute from storage. I just don't know if there is enough information out there.
Excellent Video
how do you deep dive into Postgres or any other DB? are there any helpful resources on Postgres particularly you used to understand how it works?
awesome video
as always, amazing explanations
Thank you for the content!
Hey Hussein. Could u do a overview of the hadoop architecture?
1000 likes : 0 dislikes; perfectly balanced as all things should be
How you know the dislikes?
@@i_am_dumb1070 "Return TH-cam Dislike" Chrome extension
@@zen-ventzi-marinov bruhh thankyou i wanted that soo badly
26:44
@Hussein Nasser
So why don't people use the WAL archives for database redundancy/backups?
Thanks a ton!
I noticed the wal dir has files from 2020. stand alone server. any reason why the system did not clean up older wal files?
Can you please make a same type of video for mysql?
thanks a lot
It's crazy how fork is still the standard mechanism to spawn new processes. It's unnecessarily expensive even with the optimizations and has thread safety issues, plus it's horrible from API perspective. We should use alternatives like posix_spawn for better efficiency, less bugs and easier to use code.
Thanks youtube for x2 speed
Less tutorial on how operating systems work and more about how Postgres works, please.
Pls do the same for Casandra
Thats a 'two blade sword' for me :D
Hussein you fucking rule dude
23:28
😞
I thought carry minati 😂
The number of adverts on this video is crazy. Constant interruptions make it harder for me to absorb the information in the video. Only got half way through then gave up.
@@HowDoYouUseSpaceBar How?
Honestly I love TH-cam Premium. I haven’t seen a single ad since it came out.
He giving this info out for free isn't he ?
Vanced
TH-cam premium in turkey is $.50 a month
do nothing... stop doing something