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
  • Sergey Mirvoda
    Sergey Mirvoda Octonica, UrFU

    Experience we've got after 5 years of developing, deploying and improving BI system http://colibri365.ru used in government. I would talk about government IT reality and our way over it. Postgres performance improvements, using of latest features, overwriting of user generated queries to help query optimizer and other tweaks and hacks to tackle limited hardware problems. These lead us to number of computer science papers and (now committed) patches to Postgres (see Andrey Borodin talks for details).

    VIDEO

  • 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

  • Алексей Лесовский
    Алексей Лесовский PostgreSQL Consulting LLC

    Streaming replication has been introduced in 2010 and quickly became one of the most popular features of PostgreSQL. Today, it is hard to imagine PostgreSQL installation without streaming replication. With its stability, high efficiency and ease of configuration one would have thought it is an optimal feature. However, while using it you might sometimes enter murky waters. This often can be resolved by using a combination of built-in and third party troubleshooting tools. In my talk I will provide an overview of these tools and explain how with their help one can diagnose, understand and eliminate problems related to streaming replication. I will also go through the most frequent issues occurring when streaming replication is used and will propose possible solutions. This talk is primarily aimed at DBAs and system administrators who use PostgreSQL in their day-to-day.

    VIDEO

  • Alvaro Hernandez
    Alvaro Hernandez 8Kdata

    Java is one of the most used languages when programming with PostgreSQL databases. Join this tutorial to learn or review the techniques to connect to postgres, best programming practices with JDBC, and to explore jOOQ, a mapper software that allows you to use the full power of SQL and postgres advanced query features while avoiding all the boilerplate code.

    This tutorial is very practical: most of the time will be dedicated to iterate through code samples. It will cover:

    • Introduction to Java and PostgreSQL
    • Ways of connecting to PostgreSQL from Java (not only JDBC!)
    • Introduction to JDBC. JDBC types. PostgreSQL JDBC
    • Code demo: JDBC with PostgreSQL. From Java 1.4 to Java 8, best practices and code samples
    • Code demo: jOOQ, a great mapper for PostgreSQL
    • Java inside PostgreSQL
    • The future of Java and PostgreSQL

    About two-thirds of the tutorial will be dedicated to iterate over code samples and demos. All the code would be available from public open-source repositories and built with maven, so that any attendee may download it and build easily to play with it during the tutorial (although not required).

    VIDEO

    Part 1

    Part 2

    Part 3

    Part 4

All talks