Современный SQL в PostgreSQL

In this session, we will go through the most important additions since the widely known SQL-92, explain how they work and how PostgreSQL supports and extends them. We will cover common table expressions and window functions in detail and have a very short look at the temporal features of SQL:2011 and the related features of PostgreSQL.

Scaling out PostgreSQL for data intensive workloads

This talk will present pg_shard, a new PostgreSQL extension for sharding and transparently scaling out PostgreSQL tables for real-time insert, update, delete and select commands across many machines. This extension opens up PostgreSQL to a range of applications for which NoSQL databases were more suitable until now. We are sharing this extension with the PostgreSQL community as an open source project.

Двунаправленная репликация - новый прорыв в возможностях PostgreSQL

JsQuery - язык запрос к jsonb с поддержкой GIN индексов

JsQuery – язык запросов c богатейшими возможностями по поиску в неструктурированной информации в полях типа JSONB. С индексной поддержкой!