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

i

When and Where

March 01 – 03, 2021
Online

>1500
participants

>50
talks

1440
minutes of networking

Selected talks

Mikhail Tsvetkov

Intel

Technical Director

Talk

Intel Technologies for PostgreSQL

In this presentation, we'll discuss Intel products and solutions intended for the Data Platform Group segment, such as Xeon 3rd Gen (4S Cooper Lake) server CPUs, PMEm 200 Series RAM and FPGA.

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

Partners

Media partners

Get our latest news!
Subscribe to our news

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

PostGIS 3.1 news