PGConf.Online 2021
program
for Attendees
Call for papers
Sponsorship

Consensus, Postgres, Multimaster

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 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.

Kohei KaiGai

HeteroDB

Chief Architect & CEO

Talk

GPU version of PostGIS and GiST-Index

This talk introduces GPU version of PostGIS and GiST-Index that we have developed as a new feature of PG-Strom.

Nowadays, our devices (like mobile phones) generate geolocational data time-by-time, and it is often utilized for area-marketing, push-delivery, disaster notification, and so on. People often use GIS technology to pick up users based on their current location. Even if area definitions are complicated polygons, PostGIS functions can generate right intersections, however, it is often highly computing intensive workloads.

GPU is designed for massive parallel computing workloads, with more than thousands cores per chip. And, we have developed PG-Strom extension to run a part of SQL workloads on GPU devices. At the upcoming PG-Strom v3.0, it newly supports several PostGIS functions and GiST-index for the computing intensive geolocational workloads.

In this talk, we will introduce the technology background, usage, implementation and benchmark result of GPU version of PostGIS and GiST-Index.

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

✖

«System Administrator» magazine is a key Russian industry publication for IT professionals, published since October 2002, included in the Russian index of scientific citation - www.elibrary.ru. The main task of the publication is to popularize the best developments of IT specialists from different countries. 90% of articles in the journal are of an applied nature, they are supplied with examples, tables, graphic material. It is a desktop tool for IT professionals and those who choose to pursue a career in IT.

System Administrator

✖