New York
Percona is thrilled to support PGConf NYC again this year. It will take place on September 23-24 in New York. We will sponsor it on a Bronze level and will also provide some additional endorsement.
Two speakers from Percona will present their talks on the event:
-
A Deep Dive Into PostgreSQL Indexing by Ibrar Ahmed.
Indexes are a fundamental feature of relational databases, and PostgreSQL offers developers and designers a rich collection of options. To take advantage of these entirely, users need to understand the basic concept of indexes to compare the different index types and apply them to different application scenarios. Only then can you make an informed decision about your database index strategy and design. One thing is for sure: not all indexes are appropriate for all circumstances, and using a ‘wrong’ index can have the opposite effect to what you intend, and problems might only surface once in production. Armed with more advanced knowledge, you can avoid this worst-case scenario! We’ll take a look at how to use pg_stat_statment to find opportunities for adding indexes to your database. We’ll look at when to add an index, and when adding an index is unlikely to result in a good solution. So should you add an index to every column? Come and discover why this strategy is rarely recommended as we take a deep dive into PostgreSQL indexing.
-
PostgreSQL Replication Conflicts: Avoiding Pitfalls by Hamid Akhtar.
Experiencing replication conflicts is not too unfamiliar a sight. Whether one experiences replication lag, slots, locks, snapshots, tablespace issues, or other conflicts, establishing a set of best practices along with using proper observability tools will help avoid potential issues. This talk focuses on what to do and what not to in order to avoid database conflicts in streaming replication setups by providing deep insight into how issues are PostgreSQL internals.
About the event.
PGConf NYC is a non–profit, community-run conference series focused on business users, database professionals, and developers of PostgreSQL, the world’s most advanced open source database. They target entrepreneurs, technologists, and decision-makers on the leading edge of data management, open source database innovation, and disruption of the database industry. PGConf NYC promotes the business of PostgreSQL as well as its use and development.
