Date: 2024-04-26
Time: 11:45–12:30
Room: Hub1
Level: Beginner
PostgreSQL interacts with Linux kernel at various points throughout its runtime. In this talk you will learn details about some such interactions and the respective scenarios where this occurs. This talk will take you through Kernel internals of some of the operations such as reading and writing to a file, buffer cache interactions, starting a new process and more. You will also learn basics of how to understand and debug bottlenecks in these interactions using tools such as strace, perf etc. Finally, this session concludes by walking through the details of some of attempts underway to use more efficient calls such as copy_file_range (to improve file data handling) and facilities such as io_uring (for async IO).