title

text

March 15 – 17 , 2017

Postrelease

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

Talks

Talks archive

PgConf.Russia 2017
  • Michael Kagan
    Michael Kagan Mellanox Technologies

    Modern high-performance and scale-out Database solutions need to move huge amounts of data between the system components. They need to perform it quickly and without delay for the end-user. While developing interconnect technologies Mellanox focuses on highest bandwidth, ultra-low latency, and advanced CPU offload capabilities. In this session Michael will tell about fast interconnect value for Database and Big Data solutions and will share Mellanox experience in building such systems in cooperation with leading global vendors.

    VIDEO

  • Dmitry  Lebedev
    Dmitry Lebedev BestPlace

    Nowadays one can make a decent urban research based simply on public datasets, making interesting and unexpected insights. In the presentation, I'll show examples of these calculations in PostGIS, the industry standard de-facto.

    But just PostGIS is not enough. You need tools to import, verify and visualize the data. It's critically important to visualize the data live, to debug your calculations and shorten iterations. I'll describe all these steps:

    1. Collecting the data: public API, OpenStreetMap; direct user input.
    2. 3rd party APIs for calculations.
    3. Visualization of GIS and other sorts of data: QGIS, Matplotlib, Zeppelin integrated with PostGIS.
    4. Debugging the calculations: live visualization (Arc, QGIS, NextGIS Web)
    5. Scripting and minimizing the chores: Makefile, Gulp

  • Илья Космодемьянский
    Илья Космодемьянский Data Egret

    Input-output (IO) performance issues have been on DBAs’ agenda since the beginning of databases. The volume of data grows rapidly and time is of an essence when one needs to get necessary data fast from the disk and, more importantly, to the disk.

    For most databases it is relatively easy to find checklist of recommended Linux settings to maximize IO throughput and, in most cases, this checklist is indeed good enough. It is however essential always to understand how the optimisation of those settings actually works, especially, if you run into corner cases.

  • Ivan Panchenko
    Ivan Panchenko PostgresPro

    A summary of what the Postgres Professional company has achieved in its two-year history:

    • Our achievements in PostgreSQL development.
    • What is the Russian Postgres Pro DBMS, and how is it related to PostgreSQL?
    • What is Postgres Pro Enterprise, and why Enterprise?
    • What about trainings and certification?

    VIDEO

All talks