Writing fast C code for a modern CPU (and applying it to PostgreSQL) (PGConf.dev 2025) скачать в хорошем качестве

Writing fast C code for a modern CPU (and applying it to PostgreSQL) (PGConf.dev 2025)

Presented by David Rowley at PGConf.dev 2025 (https://2025.pgconf.dev) In the past 20 years, year-on-year CPU clock speed increases have slowed. Performance increases now mainly come from doing more work per clock cycle. How much work a given CPU can do per clock cycle does not only depend on the CPU's design, it depends on the code that it's executing. This talk will take the audience through the world of modern superscalar CPUs and discuss some of the tricks they utilize to execute code as fast as possible, touching on subjects like branch prediction and cache prefetching. With each concept, we'll talk about possible adjustments that can be made to the code to make the CPU's job easier and allow it to execute the code faster. Finally, the talk will touch on some tools that can be used to find performance bottlenecks so that people know where to focus their efforts in making improvements. https://www.pgevents.ca/events/pgconf... 🎬 See more PGConf.dev 2025 videos at    • PGConf.dev 2025   Connect with us: LinkedIn:   / post   X   / pgconfdev   Mastodon: https://mastodon.social/@pgconfdev Bluesky: https://bsky.app/profile/pgconf.dev Web: https://pgconf.dev #postgresql #PGConfDev