Time: 11:10 - 12:00
Postgres has a rich type system and a wide variety of index types, and few people make full use of them or even understand what the possibilities are. This talk discusses how the design of Postgres makes it possible to combine features like arrays, enumerations, JSON/JSONB, GIN indexes and full-text search support (with ranking, similarity, spelling correction, multilingual support, and geospatial queries) to implement advanced data access patterns that are faster and more featureful than one expects from a traditional SQL database.
This combination makes it practical to just use Postgres in many situations where established wisdom is to duplicate some of your data for use by a non-relational database (like a full-text search engine or a NoSQL database).
The following slides have been made available for this session: