PGConf.Online 2021:
program
for Attendees
Call for papers
Sponsorship

psycopg3: all the love between Python and PostgreSQL

March 01 – 03 | Online

PGConf.Online 2021

What is PGConf.Online 2021?

About

PGConf.Russia is a leading Russian PostgreSQL international conference, annually taking together more than 700 PostgreSQL professionals from Russia and other countries — core and software developers, DBAs and IT-managers. This will be the first experience PGConf.Online

When and Where

March 01 – 03, 2021
Online

>1500
participants

>50
talks

1440
minutes of networking

Selected talks

Andrey Zubkov

Postgres Professional

Senior DBA

Talk

New features of pg_profile/pgpro_pwr - historical workload profiler

This talk is about postgres extension pg_profile - simple historic database workload profiler. I'll describe it's architecture, features and use cases. There is a new branch of pg_profile called pgpro_pwr, designed to run in PostgresPro Enterprise Edition and PostgresPro Standard Edition databases. It is using extended performance statistics of those databases providing some valuable benefits.

Slides

Nikolay Samokhvalov

Postgres.ai

Founder

Talk

Automated database migration testing

In a heavily-loaded project, any change implies non-zero risks of downtime or performance degradation. We constantly see how system complexity, number of database nodes, deployments per week constantly grow. How grows the level of automatization of various activities in CI/CD pipelines, containers, Kubernetes.

Meanwhile, when we look at the topic of testing of database changes–from trivial index creation to complex, almost "surgical" operations like converting int4 PK to int8 one in a multi-terabyte database under load–here we observe an obvious lag in technology and methodology development. In the best case, the changes are verified and approved visually, and here it all depends on the level of experience and tiredness of the reviewer.

In this talk, we will look at how we (Postgres.ai) solve this problem using our solution, Database Lab:

instant provisioning of independent thin clones of multi-terabyte databases, ready to be used for testing,
integration with existing CI/CD solutions and workflow,
collection of metrics that are the most useful for decision support on whether or not each database migration has to be approved (and even fully automated rejection of the most dangerous actions).

Program All talks

Recall the event

All photos

Gold partners

✖

Nutanix is a global leader in cloud software and a pioneer in hyperconverged infrastructure solutions, making computing invisible anywhere. Organisations around the world use Nutanix software to leverage a single platform to manage any app at any location at any scale for their private, hybrid and multi-cloud environments.

Nutanix

✖

Nutanix

Partners

✖

Established in 1991, FORS is one of the largest developers of Oracle-based systems in Russia, CIS and East Europe. The company delivers Oracle optimized infrastructure software-hardware solutions and offers full range of IT-services, including IT-consulting, development, integration, implementation and maintenance of systems and applications.

The portfolio of the company includes over 2000 successfully delivered IT-projects of various magnitude and complexity at almost all industries. FORS developed a number of proprietary ready-to-market solutions for finance, telco, government, medicine and sports.

FORS Group operates its own FORS Technical Support Center and has a first-line service right for Oracle Software support. All FORS Technical Support specialists are highly qualified and annually pass Oracle Certifications (Oracle Certified Professional and Oracle Certified Master Degrees).

FORS Engineered Systems Center plays a major role in adopting of Oracle Engineered systems. FORS is authorized by Oracle to assist ISVs to achieve Oracle Exastack Optimized and Oracle Exastack Ready status.

Being set up in 1994, FORS Training Center is authorized by Oracle for that kind of activities. It is also an official Partner of Pearson VUE. Since 2015 TC FORS is authorized by Postgres Professional company as authorized training center.

✖

Media partners

Get our latest news!
Subscribe to our news

I provide consent to process my Personal Data

Feedback

Conferences like this give people a personal feeling for the software. You can understand why people are passioned about it. They get confidence in using it and confidence that the software is gonna be around for a long time. The conference has people who is responsible for and designing Postgres. And I really think it excites to continue using Postgres.

Bruce Momjian

Enterprise DB Senior Database Architect
This is a very technically oriented conference. There is a lot of knowledge sharing happening. A lot of really talented people. And it is also for us a great opportunity to tap into the Russian market, a very interesting market for Postgres.

Alvaro Hernandez

OnGres CEO