PL/pgSQL is a very robust development language that allows 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 and become 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
Want your company to pay for your attendance at the conference?
Copy this letter form, fill in your personal details and send it to your chief executive.
I would like to attend PG Day’16 Russia conference,
devoted to PostgreSQL databases, that will take place on 5-8 of July in St. Petersburg.
At the conference I will have an opportunity to:
Systematize my current knowledge about PostgreSQL DBMS and obtain the new ones;
Receive guidelines on maintenance and operation of PostgreSQL;
Improve my personal skills with PostgreSQL;
Get the latest information about the community;
Improve my efficiency by means of taking advice from the most prominent PostgreSQL experts and adopting best practices of colleagues from other companies;
Get new ideas and find out more about innovative modes of operation.
This is an estimate list of expenses:
Approximate cost of flight tickets —  rur
Approximate cost of accommodation —  rur
Conference attendance —  rur
Total amount —  rur
On return I will make an 1 hour report for my colleagues and highlight the most interesting issues of the conference and offer testimonials to help improve efficiency of the team.
Looking forward to hearing from you as soon as possible!
Calculate individual costs for corporate attendance
Fill out the form, and we will reply with details of the payment as soon as possible.