
Hussein Nasser
@hnasr • 85,476 subscribers
Backend and Database Courses https://t.co/Qonec4YftL YouTube https://t.co/FfDg8cnVCI Author of https://t.co/PcX2tDsIxC Engineer @esri
Shorts
Videos

How Postgres 17 improves IN queries In prior releases, postgres would loop and do multiple "primitive" index scans as many as your IN elements. In Postgres 17 it takes an array and eliminates the need for multiple scans. This only applies for constant values
Hussein Nasser143,151 просмотров • 1 год назад

Asynchronous IO is the best feature In Postgres 18 yet. PG 18 has been released with many exciting features such as UUIDv7, Over explain module, composite index skip scans, and the most anticipated asynchronous IO with worker and io_uring mode which I uncover in this show. Hope you enjoy it 0:00 Intro 1:30 Synchronous vs Asynchronous calls 3:00 Synchronous IO 6:30 Asynchronous IO 10:00 Postgres 17 synchronous io 17:20 The challenge of Async IO in Postgres 18 20:00 io_method worker 23:00 io_method io_uring 29:30 io_method sync 31:08 Async IO isn’t done! 31:30 Support for backend writers 32:36 Improve worker io_method 33:00 direct io support 37:00 Summary
Hussein Nasser43,962 просмотров • 8 месяцев назад

Memcachd Crash Course 0:00 Intro 4:40 What is Memcached? 7:45 Memory management 16:00 LRU 25:17 Threading and Connections 30:40 Read Example 34:30 Write Example 36:17 Write and Read collisions 39:40 Locking 40:30 Distributed Cache 43:30 Memcached with NodeJS
Hussein Nasser57,095 просмотров • 1 год назад
Больше нет контента для загрузки