September 2324 |  Academpark, 12, Nikolaeva, Novosibirsk

PGConf.Siberia 2017


What is PGConf.Siberia 2017?

DevFest Siberia is a part of the IT conference series around the world for developers, managers, students. It is organized by a non-profit community Google Developers Group. This year, the conference will take place on the 23rd-24th of September in Novosibirsk, Russia.

Selected talks

Talk

ORM for .Net development, PostgreSQL and performance

Several years ago it was like that, you say “.Net developer” mean Windows and Microsoft SQL Server developer. But time flies, things change. Microsoft became a platinum member of the Linux Foundation, real .Net Core applications work on Linux/Unix servers, PostgreSQL's popularity goes up including .Net projects.

In my speech I will compare several popular ORM frameworks and tell how to make them work faster. I’ll tell about Dapper-Dot-Net “micro ORM” in a nutshell, that doesn’t generate SQL commands, it just maps DB-records to C# objects, but does it very fast. Also, it’s possible to combine different ORM frameworks with each other to improve performance.

The most interesting thing I want to talk about is how to accelerate insert and update operations using the peculiar properties of «Multi Insert» and «Upsert» in PostgreSQL. I’m gonna make a real-time demo of inserting and then updating one million records to PostgreSQL instance running on ordinary notebook with Windows in a just a few seconds, using ORM.

Talk

PgProBackup - the right way to do Postgres backup

The talk describes the existing solutions for backup and restore for PostgreSQL, including barman, pgbackrest and pg_probackup utilities. The comparison of their functions with analysis of theis drawbacks and advantages will be presented. You will learn how to setup a block level incremental backup with compression and integrity verification.