Ditch Elasticsearch and Use a Real Database for Full Text Search
Wednesday, September 11 at 11:10–12:00
Auditorium
Intermediate
Do you really need a search engine for data that's already in your database? You can use PostgreSQL for that!
An introduction to the rich but confusing field of Full Text Search in PostgreSQL will explain the concepts involved.
We will discuss:
- Textual types in PostgreSQL
- Text search and full text search
- Matching, functions and operators
- Dictionaries and collations
- Indexing in Postgres in relevance to searching for text
We will then look at practical examples with mock and realistic data and finally some performance stats.