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 работает внутри контейнеров Parallels и сравним его производительность с PostgreSQL, работающем на хосте без виртуализации.
This talk will introduce about the Postgres community in China. It will discuss about how Postgres community is organized in China, the major events we have in the past two years, also it will introduce some use-cases like game, ticket booking, app store, data warehouse in China. It will give a general idea of how Postgres is using in China.
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.