Chapter 4 Perform Fast Queries with Advanced Postgres Indexes

Our users can now securely log in to Shine using a well-designed login form, which was a great way to get a taste of what Postgres and Bootstrap can offer. In the next few chapters, you’ll implement a customer search feature, digging deeper into Postgres and Bootstrap. You’ll also start learning Angular in Chapter 6, Build a Dynamic UI with Angular.

In this chapter, you’ll implement the basics of our search, which will perform poorly. This allows you to learn about the advanced indexing features of Postgres that will speed this search up without changing any code or setting up new infrastructure. You’ll also learn how to understand query performance in Postgres, so you can be ...

Get Rails, Angular, Postgres, and Bootstrap, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.