How PostgreSQL Interacts with the Disk
summary
Explains why a database needs disk storage and how PostgreSQL interacts with disks, contrasting PostgreSQL’s behavior with other databases. Covers hardware, OS, filesystem and PostgreSQL configuration choices (RAID controllers, SSD quality, memory vs disk tradeoffs), and practical advice for selecting and tuning a setup or mitigating suboptimal hardware.
AI-written summary · about
chapters (13)
- 0:00Introduction
- 1:14Why databases need disk
- 2:59PostgreSQL specifics and bottlenecks
- 5:53PostgreSQL disk interaction
- 8:23Checkpoint issues
- 10:30Monitoring and diagnostics
- 13:38Hardware selection
- 17:47Filesystem tuning
- 20:19OS and parameters
- 23:49Checkpoint tuning
- 27:46Autovacuum tuning
- 31:40PostgreSQL in VMs
- 34:52Q&A
related talks
42mPostgreSQL Distributed: Architectures & Best practices
47mWhat If We Opened PostgreSQL's Hood?
41mLinux IO internals for PostgreSQL administrators in 2023
30mPostgreSQL and Linux Kernel interactions
48mData Horizons With Postgres
46mHow PostgreSQL Can Hurt You When You Least Expect It
49mHow Databases Work - For Developers, Accidental DBA's and Managers
51mPostgreSQL Panel Discussion