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

Postgres Pro Data Compression (CFS) for 1C ERP platform data

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

Bo Peng

SRA OSS, Inc. Japan

Engineer

Talk

Deploying PostgreSQL Cluster with Query Load Balancing and Monitoring Capabilities on Kubernetes

Kubernetes is an open source container orchestration platform for automating deployment, scaling and management of application containers. Nowadays, more and more applications are being deployed in containers on Kubernetes.

There are several solutions that can help us to run a PostgreSQL cluster on Kubernetes. However, these solutions don't provide query load balancing capability. In this talk, I will show you how to combine PostgreSQL Operator with Pgpool-II to deploy a PostgreSQL cluster with query load balancing capability on Kubernetes.

Monitoring is a very important part in production environments. Although Kubernetes provides a basic way to monitor the status of a PostgreSQL cluster, this is not sufficient for managing a PostgreSQL cluster in production. An important improvement of Pgpool-II 4.2 release is the ability to output more useful statistics of the PostgreSQL cluster. In this talk, I will describe how to monitor and visualize the PostgreSQL cluster statistics in Prometheus for extensive cluster monitoring.

Andrey Lepikhov

Postgres Professional

Software Developer

Talk

How query execution history can help with re-execution

Postgres is able to build optimal query plans for most practical cases. However, sometimes, for objective reasons, for complex queries or because of open issues in the planner itself, it can make mistakes and produce a suboptimal plan. Because of this, the execution time of such a request can increase tenfold. If the query is executed frequently, then from time to time this query takes longer than it could, and the DBMS as a whole produces a lower TPS. If the planner is able to record his mistakes and take them into account in the subsequent planning of the same query, then this will improve the characteristics of the DBMS during its operation. We present the results of the development of a PostgreSQL DBMS extension that stores the query execution history and implements the planner recommendation mechanism. We show how knowledge about previously executed queries can improve the performance of subsequent ones.

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 updates

I provide my 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