Bruce Momjian

Postgres Extended Features Presentations


Making Postgres Central in Your Data Center

Duration: 45 minutes, 1 hour with questions
Postgres has the unique ability to act as a powerful data aggregator in many data centers. This talk shows how Postgres's extensibility, access to foreign data sources, and ability handle NoSQL-like and data warehousing workloads gives it unmatched capabilities to function in this role.

YeSQL: Battling the NoSQL Hype Cycle with Postgres

Duration: 45 minutes, 1 hour with questions
Relational databases are regularly challenged by new technologies that promise to make SQL obsolete, but the new technologies often fade into obscurity. This talk explores how new NoSQL technologies are unique, and how existing relational database systems like Postgres are adapting to handle NoSQL workloads.

Non-Relational Postgres

Duration: 45 minutes, 60 minutes with questions
Postgres has always had strong support for relational storage. However, there are many cases where relational storage is either inefficient or overly restrictive. This talk shows the many ways that Postgres has expanded to support non-relational storage, specifically the ability to store and index multiple values, even unrelated ones, in a single database field. Such storage allows for greater efficiency and access simplicity, and can also avoid the negatives of entity-attribute-value (eav) storage. The talk will cover many examples of multiple-value-per-field storage, including arrays, range types, geometry, full text search, xml, json, and records.

Flexible Indexing with Postgres

Duration: 45 minutes, 1 hour with questions
When considering database indexing, many people are confused by the many Postgres indexing structures available, and the many data-type-specific index lookup methods. For example, brin allows for efficient indexing of many columns. gin indexing specializes in the rapid lookup of keys with many duplicates — an area where traditional btree indexes perform poorly. This is particularly useful for json and full text searching. GiST allows for efficient indexing of two-dimensional values and range types. This talk explores the various indexing features of Postgres and when to use them. This is ideal when presented after my Non-Relational Postgres presentation.