Conference Sessions - PGConf NYC 2021

The following list contains all the talks that have been approved so far for PGConf NYC 2021. Note that they may not yet have been scheduled! You can find the full conference information at the conference website.

Session (45 minutes)

• A Deep Dive into PostgreSQL Indexing (Ibrar Ahmed)
• Advanced Data Types in PostgreSQL (Andreas Scherbaum)
• Advanced Int->Bigint Conversions (Robert Treat)
• Advanced Postgres Schema Design (For Scalable Application Development) (Sehrope Sarkuni)
• Chasing unicorns : 0 dataloss and 99.999% availability (Lætitia Avrot)
• Data Security using Roles, Privileges and Row Level Security (Abbas Butt)
• Do it in SQL: pgbouncer_wrapper (David Fetter)
• Evolution Of PostgreSQL Replication and High Availability (upto ~ 99.999%) (Stacy Scoggins, Vibhor Kumar)
• Flexible Indexing with Postgres (Bruce Momjian)
• Get Your Insecure PostgreSQL Passwords to SCRAM! (Jonathan S. Katz)
• How PostgreSQL aggregates work (through pictures) and how to create and use custom aggregates effectively (David Kohn)
• How to improve PostgreSQL Monitoring and Observability with PMM (Agustin Gallego, Charly Batista)
• How we made PG Fitter, Happier, More Productive (Andrew Atkinson)
• Identifying Slow Queries and Fixing Them! (Stephen Frost)
• Managing PostgreSQL changes for the Agile DBA (Ryan Booz)
• Migration validation made easy with Ora2Pg (Gilles Darold)
• NORM: No ORM Framework (Henrietta Dombrovskaya)
• Pglog: a flexible log analyser (Lætitia Avrot)
• Postgres and Json - How to get the best of them? (Charly Batista)
• PostgreSQL Query Performance Insights (Hamid Quddus Akhtar)
• PostgreSQL sharding, state of the art (Julien Tachoires)
• PostgreSQL support: The most funny encounters (Hans-Jürgen)
• Row Level Security Explained (Stephen Frost)
• So You Inherited A Database (Corey Huinker)
• Speaking and Community Involvement for the Introvert (Pat Wright)
• Typo Positive: When Collection Doesn't Get You What You Need (Renee Huinker)
• Understanding and Reducing Application Contention (Simon Riggs)
• Understanding of Jsonb Performance (Oleg Bartunov)
• What's new in PostgreSQL 14 (Magnus Hagander)
• When it all GOes right (Pavlo Golub)
• When it All Goes Wrong: Database Incident Response Dos and Don'ts (Christopher Travers)
• Will Postgres Live Forever? (Bruce Momjian)
• Working together with Software Engineers: PostgreSQL as a development tool (Henrietta Dombrovskaya)