Talks
-
Integers, Arrays, Foreign Keys, Inheritance
The talk will cover several patterns of using arrays, including query optimizations in comparison with classical relational model which has no arrays; making referential integrity with arrays, and when table inheritance is used.
-
Shift-left Testing for Database Changes
How to scale the processes of development and testing of database schema and code in fast-growing projects.
-
EXPLAIN: beyond the basics
EXPLAIN is a deep topic, and to do a good introduction talk, you have to skip over a lot of the tricky bits. As such, this talk will not be a good introduction, but instead a deeper dive into some of the things most don’t cover.
-
Protecting your data with Patroni and pgbackrest
Patroni is a solid and reliable HA tool. Pgbackrest is the perfect choice to have a proper DR solution in place. The talk will walk the audience through the configuration of patroni coupled with pgbackrest.
-
Unleash the Power within pgBackRest
Have you already installed pgBackRest but are now wondering if you discovered all of its possibilities? This talk will start from a base installation of the tool and then deep dive into its richer features for more expert use.
-
Upcoming PostgreSQL 14 Features
This talk explores the new features coming in the next PostgreSQL release. This talk changes for every release.
-
Can Postgres scale like DynamoDB?
Join this talk to learn more about DynamoDB’s architecture, similarities and differences with Postgres, and understand how Postgres may scale in a similar way.
-
Миграция в облако: технологии, люди и процессы
Облако предоставляет множество технологий, включая PostgreSQL as a Service.
Не всегда и не во всех компаниях можно просто взять и начать использовать облако, а тем более СУБД в облаке.
Поговорим о том, какие могут быть возражения у службы безопасности и какие именно технологии обеспечивают безопасное использование облака. Обсудим то, как можно организовать сетевую связность с облаком. Ну и немного о том, как облегчить переезд баз, если всех убедили. -
-
Алгоритмы и структуры данных: PostgreSQL Edition
Что нормальному человеку нужно для счастья? Динамический и ассоциативный массив, немного очередей и графов, да горстку битовых операций. Но в погоне за масштабируемостью и миллионами транзакций в секунду сон разума рождает велосипеды. Так например, стандартный способ создать мапу у нас называется "Andres's steampunk macro-based robinhood template".
В докладе я расскажу о суровом, но зато нескучном быте разработчика PostgreSQL. Полезно для кругозора, но, возможно, вы захотите развидеть что-то из этого. -
Logical Replication in Postgres
Logical replication in postgres: What is logical replication? When to use logical replication? Architecture of logical replication:
- Publications
- Subscriptions
- System tables/views
- Logical replication statistics
- Restrictions
- Current work
- Future work -
Greenplum в корпоративной аналитической платформе Сбера
Подход к применению Greenplum в аналитической платформе Сбера. Архитектурные решения, способы применения и scope решаемых задач.
-
Инструменты от Data Egret для облегчения администрирования баз данных. Что и в каких случаях применять?
Пройдёмся по инструментам из https://github.com/dataegret/pg-utils, опишем, что делает тот или иной инструмент, покажем примеры использования и в каких случаях их применять.
-
Implementation of HighLoad BI on PostgreSQL in enterprise corporations: the experience of Luxms Group
Data-centric architecture Luxms BI.
High performance docking from PostgreSQL: ClickHouse, Redis, Greenplum.
PosgteSQL Clusters on Partoni.
How to connect PostgreSQL and microservices.
PostgreSQL as the Integration Core of the Enterprise Landscape.
Business logic on PostgreSQL based on the experience of implementations in Russian Railways, GPN and Rostelecom. -
What's new about monitoring in PostgreSQL
It is well known PostgreSQL has a lot of systems statistics which is useful for observing how Postgres works. Almost all of Postgres monitoring tools and plugins are based on that statistics. Despite of a lot of stats already present, a new statistics added at every new release. In this talk I going to make an overview about statistics tools added or extended in last Postgres releases. I going to talk about where these stats can be useful and how to use it with practical examples. This talk will be useful for system and database administrators who interested in monitoring.
-
Microservices and Databases, a Smart combination
Microservices are a useful concept. But there are a few things to consider when microservices need to interact with a “traditional” database, RDBMS or data-store.
In some cases, you can even have your RDBMS (Oracle, PostgreSQL or mySQL) take up the role of a microservice, and achieve remarkable efficiency.
