PGConf.Russia 2015

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.

Обзор основных компонентов архитектуры и обработки пользовательских запросов.

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.

Высоконагруженное облачное ERP-приложение с относительно тяжелыми запросами к БД