Distributed Point-In-Time Recovery with Postgres

February 05 – 07 | Lomonosov Moscow State University, Moscow, Russia

PGConf.Russia 2018

What is PGConf.Russia 2018?

About

PGConf.Russia is a leading Russian PostgreSQL international conference, annually taking together more than 500 PostgreSQL professionals from Russia and other countries — core and software developers, DBAs and IT-managers. The 3-day program includes training workshops presented by leading PostgreSQL experts, more than 40 talks, panel discussions and a lightning talk session.

i

When and Where

February 05 – 07, 2019
Lomonosov Moscow State University,
Faculty of Economics, Moscow, Russia, 1-46 Leninskiye Gory

>500
participants

>50
talks

1440
minutes of networking

Selected talks

Egor Rogov

Postgres Professional

Expert

Tutorial

Tutorial: More indexes, good and various

"And telling GIN from SP-GIST was quite beyond his wit, we found", said the classic. Can you? This masterclass is about not-so-often used index types (compared to conventional B-tree) which however can do a great job for you. We will look into internal mechanics of these indexes and discuss cases where they can be successfully applied. Also we will talk about some peculiarities of PostgreSQL index access. To spend time efficiently, listeners are required to have basic knowledge of PostgreSQL and should be used to read plans of simple queries.

Materials of the master class

Backup copy of the database with demo data can be downloaded here:

Recovery with pg_restore (338 MB)

Slides

Christopher Travers

Adjust GmbH

Database Administrator

Talk

PostgreSQL at 20TB and Beyond

In the last six months I have been working with a massive OLAP environment with 20TB shards, spanning around 400TB of data. Come to listen to how we make it all work, the challenges, and the skills involved. This talk has very little in common with the 10TB and Beyond talk because the data environments are very different.

We will cover analytics performance, data alignment, reasons for building extensions in C, and moving data around between servers in multiple data centers.

Slides

Program All talks

Recall the event

Main partners

Lomonosov Moscow State University

National center for Digital Economy

Economics Department of Moscow State University

Silver 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