HighLoad++ Armenia Hub

Level Transactional queues in PostgreSQL

Databases and storage systems

The talk was accepted to the conference program

Abstracts

Short abstract
We’ll look at a problem requiring to use of transactional queues. Also, you’ll see how to make a bulletproof queue in your PostgreSQL and look through existing alternatives.

Full abstract
The talk is about a recipe for the transaction inbox pattern (https://microservices.io/patterns/data/transactional-outbox.html) for PostgreSQL.

This pattern allows an atomic update in PostgreSQL and an external queue (or another service).

The implementation is pretty challenging, so there is a recommendation to use a ready-to-go solution like PgQ (https://github.com/pgq/pgq). But PgQ has some disadvantages (requires demon-process along with PostgreSQL, provides generic queues that are redundant, has a lack of documentation), and doesn’t fit for all (doesn’t applicable for managed DB).

Igor is a lead of backend developer at Toloka, a global tech company that develops a platform and environment to support data-related processes. Has been practicing web development for ten years using Java and PostgreSQL. Has master's degrees in Computer Science and Business Administration

-

More talks in this section

Databases and storage systems

Photo

Peter Zaitsev is CEO and co-founder of Percona.

Peter Zaitsev

Percona

Photo

Peter Zaitsev is CEO and co-founder of Percona.

Peter Zaitsev

Percona

Photo

I’ve been involved in database development and research for over 20 years, one of the core developers...

Konstantin Osipov

ScyllaDB

Photo

Peter Zaitsev is CEO and co-founder of Percona.

Peter Zaitsev

Percona

Photo

Sergey is a passionate technology “driver”.

Sergey Pronin

Percona

Photo

Daniël has been working as a DBA for many years and is now working as Technical Support Engineer for...

Daniël van Eeden

PingCAP

Photo

Jordan Pittier is a SRE at Gorgias.

Jordan Pittier

Gorgias

Photo

Peter Zaitsev is CEO and co-founder of Percona.

Peter Zaitsev

Percona