Home » Events » Flexible Document Storage with Postgres

Flexible Document Storage with Postgres

Bruce Momjian

Vice President

Non-relational Postgres.

The meetup has ended

Postgres has always had strong support for relational storage. However, there are many cases where relational storage is either inefficient or overly restrictive. Postgres is a flexible relational database, designed to be extensible from its inception. One aspect of this extensibility is document storage.

Postgres has many features designed to manage document data effortlessly, including full text search, JSON, trigrams, and specialized indexing methods to allow efficient data access. This talk will cover all of these features.


✅ Why non-relational storage?

✅ XML: Storing and working with XML documents in Postgres.

✅ JSON: Native support for storing, querying, and manipulating JSON data in Postgres.

✅ JSONB: Taking JSON handling to the next level with binary JSON in Postgres.

✅ Character strings: Managing and optimizing document text data.

✅ Document-optimized indexing: Leveraging specialized indexing methods like trigrams, GIN, and GiST for efficient searching and retrieval.

The meetup has ended. The recording is available exclusively for registered users.

About the Speaker

Bruce Momjian

Vice President

Bruce Momjian is co-founder and core team member of the PostgreSQL Global Development Group, and has worked on PostgreSQL since 1996. He has been employed by EDB since 2006. He has spoken at many international open-source conferences and is the author of PostgreSQL: Introduction and Concepts, published by Addison-Wesley. Prior to his involvement with PostgreSQL, Bruce worked as a consultant, developing custom database applications for some of the world’s largest law firms. As an academic, Bruce holds a Masters in Education, an honorary doctorate, was a high school computer science teacher, and lectures internationally.

Related Events

MongoDB Access Control – working with roles and privileges.

Master MongoDB Access Control! This webinar by Adamo Tonete teaches you how to leverage roles, privileges, and RBAC to secure your MongoDB data.

Find out more
23 May 2024