Jeremy Schneider @jer_s
Database Engineer at GEICO tech
About
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.
putting words in order without losing your mind or your data
presented by Jeremy Schneider
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...
more Wed 6 2024 OpsA deep dive into PostgreSQL backups, major upgrades, and transportable databases
presented by Jeremy Schneider
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...
more Ops and AdministrationA deep dive into wait events on PostgreSQL
presented by Jeremy Schneider
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...
more Ops and AdministrationA deep dive into wait events on PostgreSQL
presented by Jeremy Schneider
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...
more Thu 19 2019 Ops and AdministrationA deep dive into wait events on PostgreSQL
presented by Jeremy Schneider
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 ...
more Thu 21 2019 Ops and Administrationpresented by Jignesh Shah, Jeremy Schneider, Abhinav Singh, and ramya kaushik
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 ...
more Cloud