This site is about a previous instance of this event. For the current event, please see the updated site.

Conference Schedule - PGConf.EU 2015

Debugging Your PL/pgSQL Code

Date: 2015-10-30
Time: 09:30 - 10:20
Room: Ballroom C+D
Level: Beginner

PL/pgSQL is a very robust development language allowing you to write complex business logic. The downside is as the complexity of your functions grows, how do you debug them? We have all used RAISE statements to print out the progress of our functions, but they can quickly overwhelm your logs becoming useless.

In this talk, we will: - Walk through the setup of 2 key PostgreSQL extensions, the PL/pgSQL Debugger and the PL Profiler - Demonstrate how the PL Profiler can identify problem areas in your functions - Setting breakpoints in functions and triggers - Stepping through PL/pgSQL functions - Discuss the performance impact of running the extensions on production environments


Jim Mlodgenski