Jeremy Schneider
Database Engineer at GEICO tech
Jeremy Schneider has been programming for 30 years and working with databases for 20 years, first focused on Oracle and later focused on Postgres. He is currently an organizer of the Seattle Postgres User Group. He is also a Postgres Engineer at GEICO tech. Bringing his background with large-scale data processing and enterprise relational databases to the table, he is helping build a next-generation hybrid-cloud database platform - enabling developers to architect and operate applications that are fast and reliable while meeting business requirements such as integration, compliance and security.
Upcoming presentations
No upcoming presentations...
Past presentations
Collation Surprises: Did Postgres Lose My Data? (2024)
putting words in order without losing your mind or your data
Comparisons are fundamental to computing - and comparing strings is not nearly as straightforward as you might think. Collations, or the ordering and comparison of strings, is continuously evolving along with all the nuances of natural language. But databases use such comparisons everywhere: for ORDER BY, the humble >, <, and = operators, btree indexes, GROUP BY, range partitioning -- even hash...
Backups, Upgrades, and Inventing a New Way to Move Data Faster
A deep dive into PostgreSQL backups, major upgrades, and transportable databases
Reliable backups and major upgrades are one of the most important responsibilities of anyone who stores data, regardless of the technologies or platforms used. Join us for a deep dive on how PostgreSQL solves these problems. Then, after a discussion of backups and upgrades, learn how these concepts were combined to invent a new way to move data between PostgreSQL databases faster than ever befo...
Wait! What's going on inside my database? Understanding PostgreSQL wait events
A deep dive into wait events on PostgreSQL
PostgreSQL 9.6 introduced wait events and PostgreSQL 10 progressed them, but what are they? What do they mean? How do I find them and how do I make them go away? Wait events are one of the most significant advancements in observability for PostgreSQL databases; their usefulness is unparalleled in troubleshooting performance. This talk will go into all that and more as we explore the world of Po...
Wait! What's going on inside my database? Understanding PostgreSQL wait events
A deep dive into wait events on PostgreSQL
PostgreSQL 9.6 introduced wait events and PostgreSQL 10 progressed them, but what are they? What do they mean? How do I find them and how do I make them go away? Wait events are one of the most significant advancements in observability for PostgreSQL databases; their usefulness is unparalleled in troubleshooting performance. This talk will go into all that and more as we explore the world of Po...
Sep 19 2019
Wait! What's going on inside my database? Understanding PostgreSQL wait events
A deep dive into wait events on PostgreSQL
PostgreSQL 9.6 introduced wait events and PostgreSQL 10 progressed them, but what are they? What do they mean? How do I find them and how do I make them go away? Wait events are one of the most significant advancements in observability for PostgreSQL databases; their usefulness is unparalleled in troubleshooting performance. This talk will go into all that and more as we explore the world of ...
Mar 21 2019
In this training session we will be combining an extended deep dive on Amazon Relational Database Service along with a hands on lab using Amazon RDS for PostgreSQL and AWS DM. As part of the deep dive we will cover the unique features of Amazon RDS for improved availability and durability. In addition, you will get hands on experience creating an Amazon RDS for PostgreSQL for high availability ...
