Chapter 6. Writing Proper Procedures
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.
