We invite you to PGConf.Online 2021

5 min


The traditional conference PGConf.Russia this year due to a fed up virus could not be held within the promised time frame in the traditional form. Therefore, while online, but on the scheduled days – from 1 to 3 March, with the hope of being offline in the future. Online makes it easier to invite foreign speakers (therefore there are relatively many of them), participants are grazing – in general, online is cheaper, so we were able to make the conference free (thanks to respected sponsors, currently Intel, Nutanix, Avito and Zabbix, the list is rather total, will be replenished).

Features of the conference format

This year we do not single out a separate day of master classes – it makes no sense. Short and long reports (22 and 45 minutes + questions) and master classes (90 minutes or more) are distributed over all three days of the conference. Some of the talks were pre-recorded by the presenters, as is customary at most online conferences, and some will be broadcast live. There will be simultaneous translation. Questions – via chat, then the presenter will answer them with the help of the presenter. After the lectures, you can go to the Spatial Chat rooms to sleep continue the discussion.

We also invite the participants to make 5-minute blitz reports and hold their own meetups. All this will be recorded during the conference.

To make it all work, we attracted friends to help – namely, the Ontico company, i.e. Oleg Bunin’s team conducting the famous HighLoad ++ conferences and others.

You can register for the conference at website until February 26

What’s in the program?

Master classes

Python hasn’t lost its popularity. In order to work with postgres from python, the psycopg2 library is used. Our guest is its author, Daniele Varazzo. In his master class Python for PostgreSQL: how to use it, how to be good at it he will give a complete overview of this library and tell you everything you need to use it.

Alvaro Hernandez – a frequent guest of PGConf.Russia – will share his experience of using PostgreSQL for Kubernetes in a master class How to convert Postgres to cloud platform

Igor Kosenkov, Postgres Pro fault-tolerant systems expert, will talk about configuring a cluster using the CRM Shell utility.

Two master classes will focus on Postgres performance – Nikolay Samokhvalov and our guest from sunny Pakistan Ibrara Ahmed.

Reports

New products, features and developments

Mikhail Tsvetkov from Intel will talk about new technologies that can increase performance DBMS: pmem, FPGA etc.

No major development news for a long time logical replication… This will be fixed by Amit Kapila, PostgreSQL Lead Developer and Committer.

Ivan Panchenko will present the latest information about the development PostgreSQL DBMS – about new features and planned directions. Maxim Orlov (Hot update) and Dmitry Ursegov (Shardman). Arseniy Sher will reveal the inner workings of the very deep development of Postgres Professional – multimaster (real, synchronous) and will explain what limitations the use of the DBMS in this mode entails. It’s Open Source! Anastasia Lubennikova will share her development results built-in partitioning PostgreSQL – what new features will appear there and what is being worked on. Egor Rogov will talk about new Postgres Pro tutorials

Andrey Zubkov will present an updated pg_profile / pg_pwr historical load analyzer (read “Power” :).

Oleg Bartunov and Nikita Glukhov will talk about their new developments in the field JSON performance improvements (and generally TOAST). The results are very interesting, in some cases JSON can work an order of magnitude faster. Dmitry Dolgov will talk about the result of his many years of work on generalized subscripting (i.e. so that you can write UPDATE... SET x[y] = ..., where x is not only an array, but also, for example, JSON).

The author of pgstrom Kohei Kaigai will tell you how to use GPU accelerate GiST indexes and PostGIS in general.

Daria Vilkova will talk about new Zabbix agent for PostgreSQL monitoring.

Dorofey Proleskovsky, Lead Developer PostGIS, will present news of version 3.1.

DBA / Devops

Robert Haas will teach us detect and fix data corruption in the database

Julien Rouault and Tatsuro Yamada will talk about the useful pg_qualstats and pg_plan_advsr extensions, as well as their work on automation of PostgreSQL configuration. Separately, Julien will talk about how you can resist change collation tables when updating system libraries (because of this misfortune, indexes built on the old table may not work correctly).

Nikolay Samokhvalov will talk about how carefully make changes to the structure of large databasesunder load, and Robert Bernier – as such bases upgrade

Dmitry Fonteyn will share his thoughts on providing high availability Postgres, and Andrey Borodin – his own, also touching on the problems capture changes from a highly available cluster

Christopher Travers will tell you how he coped with vraparaund

Ibrar Ahmed will do A Comprehensive Overview of Data Security in PostgreSQL

Let’s talk about backup too: David Steele will talk about pgBackRest, and Artyom Kartasov – about WAL-G

Alvaro Hernandez and Fabrizio Mello will talk about the use proxy servers Envoy for postgres and monitoring network traffic through it.

Andreas Scherbaum explains how to install and configure postgres via Ansible

Yugo Nagata will talk about his development for a quick incremental update of materialized views

Bo Peng will talk about how to build a cluster with balancing PgPool-II in Kubernetes

Alexander Nikitin will reveal some pitfalls of copying bases from pg_dump and pg_basebackup, and Pavel Stehule – on how to make working with psql more convenient using pspg pager

Ivan Chuvashov from the Okko online cinema will share his experience of DBA with highly loaded systems.

1C

Anton Doroshkevich from Infosoft will share his experience andUsing data compression in PostgreSQL for 1C bases. The result promises to be interesting not only for 1C lovers. In addition, in a dialogue with Fedor Sigaev, a leading contributor to PostgreSQL, he will discuss the main problems of the bundle “1C + Postgres“.

Development and migration

Alicia Kuharchik from Microsoft will talk about migration to Postgres from “another popular database” using ora2pg, will explain how the correct use of knowledge of postgres capabilities helps to combine migration with query optimization so that the new database works faster than the old one, and Alexander Lyubushkin and Yulia Golubeva will talk about the new migration tool they have developed with a complex name LUI4ORA2PG… About data migration between the same DBMS with FDW by Daniel Westerman.

David Templeton will share his experience of creating data warehouse, and Konstantin Evteev will tell you how data warehouse and online analytics organized in X5.

Ivan Frolkov will throw a petrol chick into a dispute about how much the database should be a clean storage and is there, in addition to harm, use of constraints

Daniele Varazzo, in addition to a master class on psycopg2, will talk about how and why he took up the processing of this product, and how psycopg3 will be better

Andrey Fefelov will share his experience and ideas on how how to obfuscate the base correctly when transferred to a test environment, and Nikolay Ryzhikov – interesting the concept of dynamically building SQL queriesinspired by closure.

Alexey Fadeev will compare Multicorn FDW and PL / Python capabilities, we will hear interesting insights into their performance. Renowned SQL guru Henrietta Dombrowskaya will talk about her new concept getting rid of the ORM

Vasily Puchkov will talk about his development experience complex system for the oil industry based on Postgres.

Disclaimer

You may not like all the talks. But this is natural – there are different levels and topics. But there is almost always a choice between two or three parallel streams. Perhaps, because of this choice, you will have to skip an interesting talk. Alas, this also happens. A bit of comfort is that the videotapes will be saved if the presenters don’t mind (in previous conferences, it happened that the presenters or their employers objected). And, of course, speaker changes and changes in the schedule are possible. This also happens online.

This is our first experience of a large online conference, so we invited an experienced technical team, undoubtedly one of the best in Russia. Nevertheless, anything is possible, please treat with understanding. We will try to make the conference the best possible for all participants. We, in turn, ask you to observe them. reasonable rules


As usual, post-conference slides and videos will be published. We will hold a warmer and more lamp offline PGConf.Russia event a little later. Follow the news – and see you online!


0 Comments

Leave a Reply