A Practical Guide to Set-Based Queries
Presented by:
Aaron Cutshall
Dr. Aaron N. Cutshall is a proven leader in Healthcare Informatics with nearly 40 years of experience in application and database analysis, design, and development. He focuses on clinical quality and massive databases. He actively speaks nationwide at conferences and user group sessions on data architecture, analytics, and professional development topics.
No video of the event yet, sorry!
Database queries, stored procedures, and poorly written functions are the main contributors to performance degradation in Postgres because it is optimized for set-based processing over procedural processing. The sad reality is that too much code is written from a procedural point of view because many database developers started as procedural programmers. Also, many applications use Postgres as data storage and do not take advantage of its incredible capabilities. This session will examine what set-based queries are, how to identify inefficient procedural processes, and how they can be rewritten as efficient set-based queries. Attendees who bring laptops will be invited to download and install Postgres to work with practical examples shared throughout the day. We can also review examples from your work environment and show how performance can be improved by changing the approach.
Goals: 1. Identify instances of procedural processes and learn how they impact performance. 2. Gain a better understanding of set-based methods and how they work. 3. Gain experience converting procedural processes to set-based methods.
- Date:
- 2025 March 18 09:00 EDT
- Duration:
- 3 h
- Room:
- Gold Coast 1
- Conference:
- Postgres Conference 2025
- Language:
- Track:
- Dev
- Difficulty:
- Easy
- Requires Registration:
- Yes (Registered: 0)