Non Relational Postgres, Bruce Momjian ( Enterprise DB)

Приглашаем на конференцию HighLoad++ 2024, которая пройдет 2 и 3 декабря в Москве Программа, подробности и билеты по ссылке: Презентация и тезисы: 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 nonrelational 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 entityattributevalue (eav) storage. The talk will cover many examples of multiplevalueperfield storage, including arrays, range types, geometry, full text search, xml, json, and records.