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

Sergey Andreev Ortikon Group

What stops the transition on PostgreSQL and how to overcome it

Several real cases from those who stopped the migration to PostgreSQL.

Presentation materials
Aleksander Sheludchenkov GK "Mitra"
Non-standard 1C cluster
- Migration of the standard 1C cluster to MPI environment - "machine to machine migration of services".
- PostgreSQL migration to GPU powered machine.
Presentation materials
Nikolay Samokhvalov Nombox LLC
Enterprise-level approach to PostgreSQL tuning: database experiments

Shared_buffers = 25% – is it too much or not enough? Or it's the right value?
How can we ensure that this – pretty much outdated – recommendation suit well our needs?
It is time to start apply enterprise-level approach to tuning postgresql.conf. Not using various blind auto-tuners or advices from old articles and blog posts, but based on the following two aspects:
1. comprehensive database experiments, conducted in automated fashion, repeated multiple times in conditions as close to production as possible, and
2. deep understanding of DBMS and OS internals.
Using Nancy CLI (https://gitlab.com/postgres.ai/nancy) we will consider a concrete example: infamous shared_buffers, under various circumstances, in various projects. We will try to figure out, how to optimize this settings for given infrastructure, database, and workload.
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