Autonomous transactions in Postgres
- What is an autonomous transaction?
- An overview of autonomous transactions in "big" DBMS: Oracle.
- Autonomous transaction logic in Postgres Pro.
- An overview of emulation methods for autonomous transactions in PostgreSQL.
- Comparing performance of the built-in Postgres Pro autonomous transaction mechanism and PostgreSQL emulation methods.
VIDEO
Другие доклады
-
Dmitry Cremer МИА "Россия Сегодня"
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 Pivotal
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 Mellanox Technologies
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 ООО «Лектон»
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.