New York
Percona is thrilled to support PGConf NYC again this year and sponsor it on Silver level. It will take place on October 3-5 in New York.
Two speakers from Percona will present their talks on the event:
PostgreSQL Query Performance Insights V2 by Hamid Akhtar.
This talk had excellent attendance in 2021. So, here it is with more and better insights.
Understanding query performance patterns are the foundation for query performance tuning. It dictates how a database cluster evolves. There are direct and indirect cost connotations as well.
With improved observability and using the right tools, you can get the best out of your existing setup and ensure that it can handle not only the average load profile but peak load. We’ll see how tools like pg_stat_activity, pg_stat_statements, auto_explain, pgBadger, and pg_stat_monitor can deliver a complete picture to help measure, analyse and optimise your queries and database system.
Beyond these tools, what to consider when building a performance configuration tool with a look at the PG configuration advisor tool..
MERGE() – a Quick Introduction by Dave Stokes.
MERGE() is a powerful function for processing data like transaction logs from point-of-sales systems. It is powerful as it allows you to insert, update, or delete data in one statement instead of using an application that requires numerous round trips between the server and the application to do the same tasks (which is much more resource and time intensive). However, this is not an easy function to learn from reading the manual. This session starts with the basics and builds so that you learn how to use the power of MERGE().
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.
