title

text

Michael Shurutov
Michael Shurutov СтандартПроект
16:00 17 March
22 мин

Autonomous transactions in Postgres

  1. What is an autonomous transaction?
  2. An overview of autonomous transactions in "big" DBMS: Oracle.
  3. Autonomous transaction logic in Postgres Pro.
  4. An overview of emulation methods for autonomous transactions in PostgreSQL.
  5. Comparing performance of the built-in Postgres Pro autonomous transaction mechanism and PostgreSQL emulation methods.

VIDEO

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

  • Dmitry Cremer
    Dmitry Cremer МИА "Россия Сегодня"
    22 мин

    Building PostgreSQL from sources for system administrators

    • why we build PostgreSQL from sources?
    • choice build options
    • dependencies
    • creation system environment
    • how to customise Linux for work with PostgreSQL
    • extra soft for PostgreSQL DBA

    VIDEO

  • Andreas Scherbaum
    Andreas Scherbaum Pivotal
    22 мин

    Introduction to Greenplum MPP Database

    Overview of the architecture of Greenplum MPP (Massively Parallel Processing) database. Explain the internals of GPDB. Show how to configure and setup GPDB. How to distribute data effectively for MPP

    VIDEO

  • Michael Kagan
    Michael Kagan Mellanox Technologies
    22 мин

    Building high-performance scale-out Database Solutions

    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

  • Philip Delgyado
    Philip Delgyado ООО «Лектон»
    22 мин

    Distributed workflow specifics in PostrgeSQL

    When working with a complex business logic, you often have to implement a workflow - a sequence of several processing steps, with each step implementing a separate part of the business logic. This is usually done with specialized queues, but if there are high reliability demands, it makes sense to do everything on PostgreSQL.

    I will describe the tasks that require a workflow implementation, offer a solution, compare it with other options, and tell you about the implementation traps and pitfalls.