Indexes and Searching

Summary

Table indexing is a sure-fire way to optimize queries. In this chapter, we introduced this topic and showed you how to create primary, unique, normal, and full-text indexes, the latter using the tsearch2 module. We then demonstrated how easy it is to create PHP-enabled search interfaces for querying your PostgreSQL tables.

In the next chapter, we’ll introduce PostgreSQL’s transactional features and show you how to incorporate transactions into your Web applications by extending the PostgreSQL data class first introduced in Chapter 31.