Ace it with ACID: PostgreSQL transactions for fun and profit Thursday 11:50 New York
Twitter: @hintbits GitHub: alexeyklyukin Company website: www.adjust.com
I am Oleksii Kliukin, I work as a Senior PostgreSQL Developer at Adjust. I am based in Berlin, Germany.
I've been working together with the PostgreSQL community for quite a while, occasionally participating in mailing list discussion, promoting PostgreSQL, speaking at different PostgreSQL conferences and working on related topics, such as replication, High Availability and running PostgreSQL on Kubernetes. Since 2015 I am one of the organizers of the PostgreSQL Meetup Berlin, where we aim to deliver high-quality talks to the local audience and bootstrap the community in one of the biggest European cities.
I had a pleasure to participate in both PGConf.EU and FOSDEM, speaking in some years and attending at others, and it has always being a blast!
I am going to touch a rather fundamental topic of transactions in PostgreSQL; however, as opposed to other talks on a subject, I will not dig deep into the internals, neither I am planning to quote the documentation. Instead, my goal to provide examples, showing many best practices and creative solutions that rely on the powerful transactional engine in PostgreSQL, exposing some useful features of that engine along the way.
I am looking forward to seeing people that just started working with PostgreSQL, as well as those that have been working with it for some time as developers or database engineers.
Basic knowledge of SQL and how transactions work would definitely help to get the most out of my talk!
"Real" stored procedures (and being able to commit a transaction and start a new one inside a single procedure) would be my pick.
If I were to pick only one that would be extremely hard; I will pick three: Peter Eisentraut's talk on stored procedures, Reinier's and Marco's talk on partitioning a 10TB table and Alexander's talk called "Highway to hell or stairway to cloud", not least because it is a cool name; oh, and most of the talks from the hacker's track as well.