After understanding transactions and locking, it is time to focus on writing proper procedures to avoid widespread problems and known issues. The goal is to cover issues that bug many people around the globe. This chapter will introduce some of the most common pitfalls when it comes to writing procedures for PostgreSQL.
The following topics are on our agenda:
Choosing the right language
Managing procedures and transactions
Optimizing procedures for indexing
Avoiding security problems
Controlling memory
All of these topics will help you to make sure that your procedures offer high performance at low risk.