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.
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
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 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.
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.
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 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.
@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.
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
Just noticed that you explain much more details in your articles than videos, switching back and forth between video and article 🤓
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!
These are some high quality and high value videos, absolutely love these videos.
Thanks
1st time I heard "I wanna spend some time to talk about oscarous architecture" 🏆😅🏆Great work man btw. Thanks!
One the amazing part which I really love about postgres is its Indexing
Excellent stuff !! A great salute to you !!
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.
still works perfectly . BLESS YOU KIND STRANGER, THANK YOU!
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.
love to support a budding artist, keep it up
26:44
@Hussein Nasser
So why don't people use the WAL archives for database redundancy/backups?
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 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.
Thank you - super helpful!
@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.
great video. thanks so much for your time making this.
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?
Great stuff as always, your efforts are much appreciated! ❤
I noticed the wal dir has files from 2020. stand alone server. any reason why the system did not clean up older wal files?
Great video!
Can you please make a same type of video for mysql?
One word:
A W E S O M E !
as always, amazing explanations
Hey Hussein. Could u do a overview of the hadoop architecture?
Great video, thanks
Please do MySql architecture video too.
Thank you for the content!
awesome video
Excellent Video
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
Pls do the same for Casandra
Thanks a ton!
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 a lot
Thanks youtube for x2 speed
Less tutorial on how operating systems work and more about how Postgres works, please.
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
23:28
Thats a 'two blade sword' for me :D
Hussein you fucking rule dude
😞
I thought carry minati 😂
do nothing... stop doing something