Guest Keynote
summary
Describes adding inet/cidr types to Postgres95, then discovering a parsing bug and that the two types are accidentally swapped (inet allows zeros when cider was intended not to), fixed in base but still standard. Describes building PGcat to ingest tens of millions of spam-sample files into Postgres much faster than the filesystem, and replacing a fragile system that was corrupting hourly. Calls for zero-copy libpq and running Postgres on object stores like Ceph/S3 to avoid terabyte dump/restore limits.
AI-written summary · about
chapters (8)
- 0:00Early database experiences
- 6:43Collaboration with Jon Postel
- 9:26Implementing Postgres extensions
- 14:04Anti-spam and PGcat
- 17:39Operational scaling challenges
- 20:43Schema management and design
- 24:02Generational shifts in technology
- 27:48The future of database design
related talks
50mHacking on Postgres: An Overview
56mPostgreSQL at low Level: stay curious!
47mPostgres & Beyond
30mLesser known features of PostgreSQL
54mLessons from two decades of hacking the proprietary value into open so
35mBreakout Session
31mKEYNOTE: Postgres 19 Hackers Panel: What’s In, What’s Out, & What’s Next
25mPostgreSQL performance tips you have never seen before