PGConf.Online 2021
program
for Attendees
Call for papers
Sponsorship

Deconstructing Postgres into a Cloud Native Platform

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

Daniele Varrazzo

Codice Lieve

Director

Talk

psycopg3: all the love between Python and PostgreSQL

Python is today one of the most used programming languages in the world: simple to learn and to use and ready to interface to any known service and protocol. psycopg2 is the most used PostgreSQL driver for Python: it offers good performance and makes the communication between the language and the database as smooth as possible.

Python has evolved enormously in the past years and its first-class support for async programming is changing the way new programs are written. PostgreSQL has evolved too: a new generation of the driver is needed to make the most of all the features it has to offer.

psycopg3 is the new generation of the most used Python-PostgreSQL adapter: it offers a familiar interface and smooth upgrade path, but behind the scenes it is engineered to obtain the best performance from the database and the language: async programming, prepared statements, binary parameters.

psycopg3 is also experimenting with innovative JSONB support and query pipelining! Come and discover the forefront of the research between your most loved language and database!

Ibrar Ahmed

Percona LLC

Senior Software Engineer - PostgreSQL Consultant

Tutorial

High-Performance PostgreSQL

PostgreSQL is one of the leading open-source databases. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. The default configuration is designed in such a way that PostgreSQL can run on any system using minimum resources. Consequently, a default installation of PostgreSQL does not give optimum performance on the high-performance machine because it is set up to use all available resources. PostgreSQL provides mechanisms that allow you to tune your database according to your workload and machine specification. Outside of PostgreSQL, though, we can tune the Linux kernel to allow the database load to work optimally. In this talk, we will learn how to tune some of the PostgreSQL’s parameters, and we will see the effect of that tuning, but we will focus on demonstrating how to tune Linux for better Postgres performance. As there are so many Linux kernel parameters that can be tuned to improve the performance of PostgreSQL, I will also share the results of benchmarks obtained when tuning some of the Linux parameters.

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

✖