1. Home
  2. SQL
  3. Postgresql

Chapter 4. Performance

In the previous three chapters, you have seen how to create new databases and tables. You have also seen a variety of ways to retrieve data. Inevitably, you will run into a performance problem. At some point, PostgreSQL won't process data as quickly as you would like. This chapter should prepare you for that situation?after reading this chapter, you'll have a good understanding of how PostgreSQL executes a query and what you can do to make queries run faster.



    		Part I: General PostgreSQL Use
    		Chapter 1. Introduction to PostgreSQL and SQL
    		Chapter 2. Working with Data in PostgreSQL
    		Chapter 3. PostgreSQL SQL Syntax and Use
    		Chapter 4. Performance
    		How PostgreSQL Organizes Data
    		Gathering Performance Information
    		Understanding How PostgreSQL Executes a Query
    		Table Statistics
    		Performance Tips
    		Part II: Programming with PostgreSQL
    		Part III: PostgreSQL Administration