RSS Amplifier

Blog

-=vyruss=- / blog

vyruss.orgRSS feed ↗100 posts

Latest posts

LISTEN Carefully: How NOTIFY Can Trip Up Your Database

My POSETTE 2026 and PG DATA 2026 talk on how PostgreSQL's LISTEN/NOTIFY can quietly bottleneck a high-throughput database, and how to fix it with unlogged queue tables, advisory locks, and batching.

LinkedIn Live: Fixing Bad SQL in PostgreSQL with Jimmy Angelakos

Sharing the video of my April LinkedIn Live session, where I break down common SQL anti-patterns from Chapter 2 of my book and fix them live in the terminal.

PostgresEDI July 2026 Meetup — Public Speaking, AI Compliance

A recap of our July meetup: Pat Wright on speaking and community involvement for the introvert, and Martins Otun on traceable, SQL-first retrieval for compliance-critical AI systems.

pg_statviz 1.0 released with AI-powered analysis

Extension pg_statviz for time series analysis & visualization of Postgres internal statistics has released version 1.0 with an optional AI analysis mode that produces per-module HTML reports with chart commentary, threshold verdicts, and concrete remediation advice from a cloud or local LLM.

PostgresEDI April 2026 Meetup Recap & May Lightning Talks

A look back at our April meetup and a call for speakers for our May Lightning Talks event! Test your talk before the PGDay UK CFP deadline.

SCaLE 23x and CloudNativePG: Robust, Self-Healing PostgreSQL on Kubernetes

I just came back from SCaLE 23x! This year I spoke about running robust, self-healing PostgreSQL on Kubernetes with CloudNativePG, and caught up with community legends.

PostgresEDI Feb 2026 Meetup — Two Talks

A recap of our second meetup! Slides and resources from Alastair Turner's talk on client failover and Sean Hammond's deep dive into transactional job queues.

FOSDEM 2026 — Defining "Drop-in Replacement" and Beyond

A recap of FOSDEM 2026 in Brussels, where Daniël van Eeden and I explored what "compatible" really means for databases, plus an announcement for the next session in Vancouver!

Panel Discussion: How to Work with Other Postgres People — PGConf.EU 2025

Floor Drees, Karen Jex and I led a panel at PGConf.EU 2025 about neurodiversity, teamwork hacks, and how diverse minds collaborate in the PostgreSQL ecosystem. Moderator: Boriss Mejías

Announcing the second PostgreSQL Edinburgh meetup

The PostgreSQL Edinburgh meetup returns! February 12th @ the University of Edinburgh's Lister Learning and Teaching Centre (pizza, networking, and talks).

pg_statviz 0.9 released with new features

Extension pg_statviz for time series analysis & visualization of Postgres internal statistics has released version 0.9 with configuration change timelines, new modules for replication, SLRU, and session age.

The Angelakos Prime Spiral: A New Way to Visualize Prime Numbers?

A doodling habit led to what appears to be a novel way of visualizing prime numbers, using the primes as step lengths in a turtle walk. The result is a surprising geometric "proof" of the Prime Number Theorem.

Announcing the inaugural PostgreSQL Edinburgh meetup

Thrilled to announce the launch of the PostgreSQL Edinburgh meetup! December 11th @ the University of Edinburgh's Old College (pizza, networking, and talks).

pg_statviz 0.8 released with PostgreSQL 18 support

Extension pg_statviz for time series analysis & visualization of Postgres internal statistics has released version 0.8 with support for PostgreSQL 18.

PGDay Lowlands 2025 and Getting Postgres to the Next Level

A recap of PGDay Lowlands 2025, where I presented our talk "How Do We Get Postgres to the Next Level?", co-written with Henrietta Dombrovskaya, in the unique setting of the Rotterdam Zoo.

FOSSY 2025 and RAGtime with Postgres

A quick recap of my trip to Portland for FOSSY 2025, where I had the opportunity to speak about building AI-powered applications with pgvector and Retrieval-Augmented Generation.

SCaLE 22x, live streams and Row-Level Security Sucks

I just came back from my second SCaLE (22x)! I broadcast 3 days of live streams from the conf, and spoke about Row-Level Security.

PGConf.EU 2024 in Athens, Extension Summit, OpenStreetMap talk, and others

PGConf.EU 2024 was huge, with new fringe events, and much enjoyment.

pg_statviz 0.7 released with new features, PG17 support

Extension pg_statviz for time series analysis & visualization of Postgres internal statistics has released version 0.7 with new features and support for PostgreSQL 17.

PGDay Lowlands and DBA Day 2024

A new PostgreSQL event has appeared, and it's DBA Appreciation Day today!

POSETTE 2024 — How to Work with Other People

Floor Drees and I just spoke at POSETTE 2024 about neurodiversity and mental health in IT & PostgreSQL Community!

SCaLE 21x — Recovering from Data Loss Despite Not Having a Backup: A Postgres True Story

I just came back from my first Southern California Linux Expo (SCaLE 21x) where I shared a true story about a remarkable PostgreSQL data recovery.

FOSSCOMM 2023 Heraklion — How PostgreSQL can help you enforce best practices

A few months back I gave a talk at FOSSCOMM 2023 in Heraklion, Greece — and the footage has just been found!

PGConf.EU 2023 — Unforgettable moments and how we rocked the house!

PGConf.EU was a huge success, with many firsts and unforgettable moments.

PGConf.DE 2023 — The Last Hurrah of "Don't Do This"?

At PGConf.DE I gave a talk about what not to do with Postgres for the last (?) time.

FOSDEM 2023 - Don't Do this

Just came back from FOSDEM 2023 where, among other things, I gave a talk about what not to do with Postgres.

PGConf.EU 2022 Berlin — PostgreSQL Community Panel: Upgradability

Just tried out a new panel talk format for PGConf.EU 2022 and feedback was great.

Fri 28 Oct 2022 22:24:49

Thank you for the knowledge sharing, the hallway conversations, the friendship, the mentorship. The speakers, organisers, volunteers & attendees made #pgconfeu 2022 a great experience. You are the people that make the #PostgreSQL community awesome! #postgres #database #opensource

Fri 28 Oct 2022 14:42:43

Hearing someone talk about migrating non-postgres applications to something that is also not #postgres #pgconfeu

Fri 28 Oct 2022 13:16:59

⚠️ @JCasanovaEC of @systemguards shows that there's still not complete feature parity between pglogical and #postgres native logical replication #pgconfeu #postgresql

Thu 27 Oct 2022 15:33:06

Whoa!? Big surprise! By show of hands, not many of the #pgconfeu attendees would support a renaming of #PostgreSQL to #Postgres!

Thu 27 Oct 2022 13:44:58

.@robertmhaas rocking the place with some real world talk #postgres #pgconfeu #postgresql

Wed 26 Oct 2022 14:40:54

Thank you so much to @samokhvalov @Karenhjex @ascherbaum for participating! Many good points and questions raised! #pgconfeu #postgres #postgresql

Wed 26 Oct 2022 10:32:31

.@gitlab speaking about how read/write query separation is necessary for single-master #postgres scaling. #pgconfeu #postgresql

Wed 26 Oct 2022 08:32:12

@magnushagander @samokhvalov @PostgreSQL What's wrong with recording our panel conversation but excluding the audience questions? Nobody's privacy is affected

Thu 13 Oct 2022 13:20:22

RT @PostgreSQL: News: PostgreSQL 15 Released!

Tue 11 Oct 2022 14:37:00

I'm hosting a #PostgreSQL Community Panel on Upgradability with @ascherbaum, @Karenhjex and @samokhvalov at @pgconfeu 2022 in Berlin in two weeks! Come say hi!

Fri 07 Oct 2022 13:29:06

RT @EDBPostgres: Full house today at EDB Postgres, Cloud and Kubernetes Day in Milan, Italy! 👏

Wed 05 Oct 2022 08:54:30

RT @pgconfeu: Read the #pgconfeu speaker interview with Tomas Vondra (@fuzzycz).

Tue 04 Oct 2022 16:03:48

RT @pgconfeu: Read the #pgconfeu speaker interview with Nikolay Samokhvalov (@samokhvalov).

Wed 28 Sep 2022 12:35:40

RT @opensourceway: Drop your database for PostgreSQL

Tue 20 Sep 2022 12:38:19

RT @planetpostgres: Hans-Juergen Schoenig (@postgresql_007): PostgreSQL: Sequences vs. Invoice numbers

Mon 05 Sep 2022 20:51:10

@brihal4457 @ascherbaum @pgexperts @Xof @pgconfnyc Make sure the Postgres service is running by checking either with Windows services or with systemd under Linux. Also check that it's actually using the default port 5432.

Thu 04 Aug 2022 15:03:32

RT @sjstoelting: Just finished some work on another #PostgreSQL foreign data wrapper #SPARQL.This one is based on multicorn2 now

Thu 21 Jul 2022 21:53:35

RT @PostgresWomen: Thanks to a very generous and anonymous donor, we have free tickets for 2 amazing women to attend pgconf Europe in Berli…

Fri 08 Jul 2022 13:47:11

So many great talk submissions to @pgconfeu. I'm quietly confident an excellent conference is brewing ☕️ #pgconfeu #postgres #postgresql #opensource #database

Thu 07 Jul 2022 20:19:57

RT @CloudNativePg: Proud to announce #CloudNativePG 1.16.0 and 1.15.2 are out!

Mon 04 Jul 2022 14:15:32

@postgre_s @johnnyq72 @d_gustafsson @l_avrot @saschild @pg_xocolatl @ascherbaum @Swiss_PGDay Discussion Paused...gres

Tue 28 Jun 2022 14:55:23

RT @ascherbaum: ctid and other #PostgreSQL table internals

Mon 27 Jun 2022 21:05:04

One hour left! Submit your #PostgreSQL talk proposal for this year's most important #Postgres event in Europe. #opensource #database #databases