PgConf.Russia 2019

Talks
Photo

PgConf.Russia 2019

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.

Thems

PostgreSQL at the cutting edge of technology: big data, internet of things, blockchain
New features in PostgreSQL and around: PostgreSQL ecosystem development
PostgreSQL in business software applications: system architecture, migration issues and operating experience
Integration of PostgreSQL to 1C, GIS and other software application systems.

more than
0 participants
0 speakers
0
minutes of conversation
63 talks
offline
format

Alex Lustin SilverBulleters, LLC
Analysis of troublesome queries as a means of recurrent refactoring of 1C code
1. Principles of searching for troublesome queries in PostgreSQL.
2. Evaluation of hypothetical indexes and their impact on query plans.
3. The most common errors in 1C-programming.
4. Basic methods of code refactoring, taking into account the features of PostgreSQL.
5. Storing analytical information from the PostgreSQL log to assess the quality of refactoring
Presentation materials
Konstantin Evteev Avito

Standby in production

My talk will be about different cases of usage and setup of the standby server; examples how to setup standby linked to your archive( to make an opportunity to recreate standby from archive after primary crashing and promoting your old standby); Avito experience of usage of standby server for read-only queries: problems and solutions; monitoring of standby.

Presentation materials
Darafei Praliaskouski Juno

PostGIS for Disaster Management

PostGIS is spatial extension for PostgreSQL.

This talk will go in depth on using PostGIS for disaster management: which functions can be used and for what.

Presentation materials
Vasiliy Puchkov ООО

Integrating PostgreSQL servers into corporate network

Meeting corporate standarts for information security, business continuity and software unification: Kerberos Authentification (Windows and Linux) in Active Directory Environment. 1C Enterprise specifics. Using backup and recovery software (HP Data Protector). Integration with corporate monitoring system (Solarwinds Mointor).

Presentation materials