title

text

February 05 – 07 , 2018

PGConf.Russia 2018

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
  • 54 talks
  • offline
    format

Talks

Talks archive

PGConf.Russia 2018
  • Christopher Travers
    Christopher Travers DeliveryHero SE

    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.

  • Alexander Pogodin
    Alexander Pogodin Corporation PARUS
    Alexander Pankratov
    Alexander Pankratov SPC Parus

    The report reviews approaches and implementattion options for the migration of Parus-Budget 8 client-server application from the Oracle Database platform to the PostgreSQL platform without changing the client application for Desktop and the Web. The proposed solution allows to make transparent transition of the existing users' workplaces.

  • Olivier Courtin
    Olivier Courtin DataPink

    • Spatial and advanced spatial analysis with pure PostGIS (including cutting edge PostGIS functions available)
    • How could we mix and tied efficiently PostgreSQL and Python data types (as NumPy ndarray, and Pandas DataFrames)
    • Tools to improve our data manipulation environment (Jupyter tricks, easy dataviz...)
    • How to go further throught GeoDataScience, with Python libs and framework tied with PostgreSQL/PostGIS (including Machine and DeepLearning)

  • Dmitry Cremer
    Dmitry Cremer Federal State Unitary Enterprise Rossiya Segodnya

    A database is one of the key components in any information system, requiring the monitoring of multiple metrics. The talk highlights examples and approaches of monitoring and analysis of PostgreSQL performance that allow to minimize the load on the database server from the monitoring and data collection system for the subsequent analysis of problem situations.

    • Quantum effects or as an observer affect the observed system
    • Features of collecting metrics while monitoring the database with Zabbix
    • Data collection for analytics and visualization PostgreSQL queries with rsyslog + kafka + clickhouse + grafana
    • Operational Analysis Tools for DB loglile

All talks

Partners

PGConf.Russia 2018

Silver

Organizational

Informational

Partner