Conference Schedule - PGConf.EU 2018

Use Logical Decoding to build your own application cache

Date: 2018-10-25
Time: 10:30 - 11:20
Room: Casablanca
Level: Intermediate

In this practical hands-on presentation we will do an overview of the Logical Decoding feature and show you how to build high performance memory based read caches using it .

We will demonstrate how to create a configurable application caching service that invalidates and updates it's entries by consuming a PostgreSQL Logical Replication Stream and demonstrate how to handle several very common use-cases for busy web and mobile application backends that need millisecond response times, without sacrificing consistency and improving availability due to reduced DB load.

We will finish with our real-world scenario where we drastically improved critical aggregate queries from several seconds to several milliseconds and reduced our server load by 40% in a 50M transactions per day environment. All this with less than 1000 lines of code.

Slides

The following slides have been made available for this session:

Speaker

Blagoj Atanasovski