Postrelease
Talks
Talks archive
-
Andrey Fefelov Mastery.proI will tell you about why Postgres is first-choice product as a foundation for your BI system with classical OLAP workload. Briefly it will be said about existing open source BI solutions.
I will also describe specific of our architecture, why we chose snowflake scheme and how we are doing extract, transformation and load procedures. It will be mentioned about special Postgres tuning for OLAP and massive data bulkload workloads. Also I will let you know about Postgres usage as a column database with cstore_fdw by Citus and results achieved. Cons and problems of our approach will be described in the end of the talk.
VIDEO
-
Michael Shurutov Postgres Professional- 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
-
Pavel Luzanov PostgresProDebugging, profiling, and tracing of the executed commands play an important role in development of any applications. This is also true for developing stored procedures in DBMS.
PostgreSQL offers various tools (both built-in and external) for these purposes.
In this talk, we will provide an overview of the available tools and their advantages and disadvantages, as well as a detailed demo of their use cases.
This talk is a part of a basic course for backend application developers (DEV1), which “Postgres Professional” company plans to announce in the near future.
-
Kamil Islamov Stickeroid AiWe will discuss some tricks and patterns while developing web-application architecture based on ORM technology with Postgresql functions implementation with Python Django as an example. Also we will consider some ways of building the business logic inside a database with keeping Django framework opportunities and implementation of it's built-in admin panel.
VIDEO
Photos
Photo archive