Flexible Document Storage with Postgres

Bruce Momjian

Vice President
EnterpriseDB

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.

Agenda:

✅ 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

blank

Bruce Momjian

Vice President
EnterpriseDB

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.

blank

Related Events

blank

How to Provision a MongoDB Cluster in Kubernetes?

This webinar offers a practical guide for deploying & managing MongoDB clusters in Kubernetes environments. Learn key strategies, pros & cons of DBaaS models, and see a live demo! Designed for developers, DevOps, and IT professionals.

Find out more
18 April 2024
Online,