In Chapter 6, Optimizing Queries for Good Performance, you learned a lot about the optimizer as well as optimizations going on in the system. This chapter is going to be about stored procedures and how to use them efficiently and easily. You will learn what a stored procedure is made of, which languages are available, and how you can speed things up nicely. On top of that, you will be introduced to some of the more advanced features of PL/pgSQL.
The following topics will be covered:
- Deciding on the right language
- How stored procedures are executed
- Advanced features of PL/pgSQL
- Packaging up extensions
- Optimizing for good performance
- Configuring function parameters
At the end of the chapter, you will be able to write good and efficient procedures.
