Date: 2025-04-25
Time: 13:00–13:45
Room: East
Level: Intermediate
This talk will explore different implementations of the publish-subscribe messaging pattern on Postgres using LISTEN/NOTIFY, contrasting it with a traditional PubSub broker like Kafka. We'll first define the pattern in simple terms, showing how it can be implemented using LISTEN/NOTIFY, then discuss a number of real world systems built and maintained over the course of years. We'll highlight the gotchas encountered in production with these systems, as well as the patterns learned while building them. This talk should be useful to an application developer who's either new to or has some experience with LISTEN/NOTIFY, and is interested in understanding when and how to use it effectively, beyond the most basic examples.
The following slides have been made available for this session: