Alex Lustin
Alex Lustin SilverBulleters, LLC
17:15 07 February
45 мин

Docker, PostgreSQL, Production ....

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


Другие доклады

  • Olivier Courtin
    Olivier Courtin DataPink
    45 мин

    Advanced spatial analysis with PostgreSQL, PostGIS and Python

    PostGIS is well known and widely used since two decades, as the best OpenSource database solution for Spatial Analysis. This talk will focus on: spatial and advanced spatial analysis with pure PostGIS (including cutting edge PostGIS functions available); how to go further throught GeoDataScience, with Python libs and framework tied with PostgreSQL/PostGIS (including Machine and DeepLearning)

  • Ivan Frolkov
    Ivan Frolkov Postgres Professional
    45 мин

    Managing transaction workflows in Postgres Pro Enterprise

    It is often required to asynchronously perform several transactions in a strictly defined sequence, not just a single transaction. There are several ways to achieve this, and one of the solutions available is the pgpro_scheduler module.

  • Ivan Panchenko
    Ivan Panchenko Postgres Professional
    90 мин

    Server side programming in PL/Perl, PL/Python, PL/v8

    Tutorial will show specifics of server programming in these languages. I will present practical examples and compare the features of these languages in PostgreSQL environment from the viewpoint of solving practical tasks.

  • Christopher Travers
    Christopher Travers DeliveryHero SE
    45 мин

    PostgreSQL at 20TB and Beyond

    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.