Chapter 3 Use 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, we’ll implement a customer search feature, digging deeper into Postgres and Bootstrap. We’ll also start learning AngularJS in Chapter 5, Build a Dynamic UI with AngularJS.
In this chapter, we’ll implement the basics of our search, which will perform poorly. This will allow 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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access