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
  • Alex Lustin
    Alex Lustin SilverBulleters, LLC

    I would like to share experience in runing PostgreSQL in dockerized environments, describe the specific issues and tools you will need to solve them.

    • Which problems could be solved by Docker for PostgreSQL, e.g. PostgreSQLPro.9.6
    • Work of IT team with Docker in development, testing and production environments
      • Using image repository and build servers for image testing
    • Issues in production environment:
      • With network activity
      • With persistent repositories for Docker
      • With additional services
      • With load balancing and fail-safety
    • Running PostgreSQL-base applications, such as:
      • SonarQube
      • Gitlab
      • 1С platform

  • Valery Kosarev
    Valery Kosarev -

    Storing binary data in database tables is sometimes a good solution for a particular project. But sometimes, due to changes in conditions or insufficient consideration of decisions, such storage is becoming a real nightmare. If there is an understanding of how and where to place these data, the transition to the new solutions are often very hard, often require modification in the application code and downtime the system for migration. The presentation is a particular solution of such problems. Our extension allows to move binary data from database to the storage Ceph and not only. And does it seamless for the applications.

  • Darafei Praliaskouski
    Darafei Praliaskouski Juno

    PostGIS is a spatial extension to PostgreSQL that enables spatial datatypes, access methods and a set of functions to perform geometric operations on them.

    Typically PostGIS is used to select a small subset of a big static dataset. In this talk I'll cover issues that arise when working with big dynamic data flows, and ways to resolve them, on examples that we've met developing Juno ride sharing service backend.

  • Dmitriy Pavlov
    Dmitriy Pavlov Arenadata

    In the pitch I will talk about the most important nuances of deployment and operations of the distributed analytical open-source database based on PostgreSQL - Greenplum. I will analyze the typical mistakes in its use, give the best practices and warn about bottlenecks.

All talks

Partners

PGConf.Russia 2018

Silver

Organizational

Informational

Partner