PostgreSQL vs. fsync How is it possible that PostgreSQL used fsync incorrectly for 20 years, and wh…
PostgreSQL vs. fsync How is it possible that PostgreSQL used fsync incorrectly for 20 years, and what we'll do about it.
by Tomas Vondra
At: FOSDEM 2019
https://video.fosdem.org/2019/K.1.105/postgresql_fsync.webm
About a year ago the PostgreSQL community discovered that fsync (on Linux and some BSD systems) may not work the way we always thought it is, with possibly disastrous consequences for data durability/consistency (which is something the PostgreSQL community really values). I'll walk you through fsync basics, explain how we always thought/assumed it works and how it actually behaves. I'll also discuss where the misunderstanding likely comes from - which is a mix of cultural and technical reasons rooted in the past. We'll see how this issue impacts current PostgreSQL deployments, what you can (and can't) do about it, and finally outline some plans for addressing it properly in the future.
Room: K.1.105 (La Fontaine)
Scheduled start: 2019-02-02 17:00:00+01
Видео PostgreSQL vs. fsync How is it possible that PostgreSQL used fsync incorrectly for 20 years, and wh… канала FOSDEM
by Tomas Vondra
At: FOSDEM 2019
https://video.fosdem.org/2019/K.1.105/postgresql_fsync.webm
About a year ago the PostgreSQL community discovered that fsync (on Linux and some BSD systems) may not work the way we always thought it is, with possibly disastrous consequences for data durability/consistency (which is something the PostgreSQL community really values). I'll walk you through fsync basics, explain how we always thought/assumed it works and how it actually behaves. I'll also discuss where the misunderstanding likely comes from - which is a mix of cultural and technical reasons rooted in the past. We'll see how this issue impacts current PostgreSQL deployments, what you can (and can't) do about it, and finally outline some plans for addressing it properly in the future.
Room: K.1.105 (La Fontaine)
Scheduled start: 2019-02-02 17:00:00+01
Видео PostgreSQL vs. fsync How is it possible that PostgreSQL used fsync incorrectly for 20 years, and wh… канала FOSDEM
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Finite element modeling with the deal.II software libraryPipeWire in the Automotive IndustryWalking through walls PostgreSQL ♥ FreeBSDIGT GPU Tools - the past, the present, the futurerustfix …and the journey to getting better code automaticallyDesigning an ultra low-overhead multithreading runtime for Nim Exposing fine-grained parallelism fo…Buildroot for RISC-V Using Buildroot to create embedded Linux systems for 64-bit RISC-Vrust-vmm shared virtualization cratesOpening talk FOSDEM 2011Secure logging with syslog-ng Forward integrity and confidentiality of system logsOpening Intel Server firmware based on OpenBMC exampleThe elfutils debuginfod serverThe HammerBlade RISC-V Manycore A programmable, scalable RISC-V fabricKata Containers on openSUSEFOSDEM infrastructure reviewThe history of error correction and detection and how it led to Ceph’s Erasure Coding TechniquesReaching const evaluation singularity An introduction into miri and Rust's const evaluationwebPh.one - connect community cellular networks using WebRTC and PWA Open Source , WebRTC and Web t…Hint, Hint, Font Loading Matters! Fonts are lovely but can slow down our loads. How can we make the…Substrate An Open-Source Framework for Building BlockchainsRspamd integration into FreeBSD.org mail infrastructure