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.
Thank you Hussein! Love your content, from all the tech UA-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.
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 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.
One the amazing part which I really love about postgres is its Indexing
These are some high quality and high value videos, absolutely love these videos.
Thanks
Just noticed that you explain much more details in your articles than videos, switching back and forth between video and article 🤓
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.
Thank you Hussein! Love your content, from all the tech UA-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!
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.
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
still works perfectly . BLESS YOU KIND STRANGER, THANK YOU!
1st time I heard "I wanna spend some time to talk about oscarous architecture" 🏆😅🏆Great work man btw. Thanks!
Thank you - super helpful!
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....
love to support a budding artist, keep it up
Great video, thanks
Please do MySql architecture video too.
great video. thanks so much for your time making this.
Great video!
Great stuff as always, your efforts are much appreciated! ❤
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.
awesome video
Excellent Video
One word:
A W E S O M E !
thanks a lot
as always, amazing explanations
Thanks a ton!
Thank you for the content!
1000 likes : 0 dislikes; perfectly balanced as all things should be
How you know the dislikes?
@@i_am_dumb1070 "Return UA-cam Dislike" Chrome extension
@@zen-ventzi-marinov bruhh thankyou i wanted that soo badly
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?
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?
@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.
Hey Hussein. Could u do a overview of the hadoop architecture?
26:44
@Hussein Nasser
So why don't people use the WAL archives for database redundancy/backups?
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.
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 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
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 UA-cam Premium. I haven’t seen a single ad since it came out.
He giving this info out for free isn't he ?
Vanced
UA-cam premium in turkey is $.50 a month
😞
I thought carry minati 😂
do nothing... stop doing something