part two
Over the years, Postgres has evolved into a general-purpose database that supports use cases beyond traditional relational workloads. In the second part of the book, we explore two core capabilities of Postgres that let us use the database to process semi-structured and unstructured text data.
We learn how to efficiently work with JSON data and perform full-text searches in Postgres using built-in operators, functions, and specialized index types. After completing this part of the book, we’ll be prepared to design and build applications that take full advantage of these core capabilities of Postgres.