iiinova — where your digital self keeps evolving

Jimmy Angelakos @vyruss.org · 02/10/2026

Apache Spark: Solving your problems the wrong, but massively parallel, way. #ApacheSpark #PostgreSQL #Graphs

Recursive graph traversal illustrated: anchor node "a" expands through depths 0–3 into nodes b–j shown in columned depth stages, alongside a WITH RECURSIVE SQL CTE example that selects id and depth and a result table listing ids a–j with their depths.

Jimmy Angelakos @vyruss.org · 30/09/2026

Next Thursday, Oct 8th, I'm speaking about 🐘🧊 #ColdFront (transparent #PostgreSQL data tiering to Apache Iceberg) at the Iceberg Europe Community #Meetup in #London! Join in person or online. RSVP: luma.com/ogtqk9eh #Postgres #ApacheIceberg #OpenSource #Database #Lakehouse

020

Jimmy Angelakos @vyruss.org · 30/09/2026

Next Wednesday, Oct 7th, I'm speaking at the #London #PostgreSQL #Meetup! I'll present 🐘🧊 #ColdFront: transparent #Postgres data tiering to Apache Iceberg for the modern #Lakehouse. RSVP: www.meetup.com/london-postg... #ApacheIceberg #OpenSource #Database

Poster for PostgreSQL London event "New Postgres Tools for Analytics" on 07 October from 18:30 with talks by Elizabeth Christensen (Snowflake), Alex Kasko (DuckLabs/AWS), and Jimmy Angelakos (pgEdge); sponsored by Snowflake; venue Doggett's Coat and Badge, 1 Blackfriars Bridge, London.

021

Jimmy Angelakos @vyruss.org · 19/09/2026

I can't believe it's been almost 25 years since Naqoyqatsi. #Naqoyqatsi #PhilipGlass #GodfreyReggio #YoYoMa

Title "Naqoyqatsi" in large red letters with a Hopi-language dictionary entry beneath: "na · qoy · qatsi (nah koy' kahtsee), n. from the Hopi Language, <each other—kill many—life>. 1. a life of killing each other. 2. war as a way of life. 3. (interpretation) civilized violence."

001

Jimmy Angelakos @vyruss.org · 18/09/2026

postgres.scot is live: one address for #Postgres events in #Scotland. Plus the August @PostgresEDI.bsky.social #meetup on logical replication and marked NULLs, and the September meetup coming up in less than a week! vyruss.org/blog/postgre... #PostgreSQL #OpenSource #Edinburgh #Database

Torsten and Paolo, each speaking beside projection screens showing SQL-like code at the PostgresEDI meetup

051

Jimmy Angelakos @vyruss.org · 10/09/2026

Nail-biting suspense! Is #PostgreSQL on a Raspberry Pi faster than a cloud managed instance?! Chris Ellis explores at @pgdaylowlands.bsky.social. #Postgres #RPI #RaspberryPi #cloud #database #OpenSource #PGDayNL

Chris Ellis on stage at PGDay Lowlands, the screen behind him showing a Raspberry Pi

020

Jimmy Angelakos @vyruss.org · 10/09/2026

@magnus.hagander.net kicking off @pgdaylowlands.bsky.social by telling us what's coming in #PostgreSQL 19, sadly without musical accompaniment. #pgdaynl #postgres

Magnus Hagander on stage at PGDay Lowlands. Slides detail the PG19 development workflow. There is also an acoustic guitar and it's case on stage.

010

Jimmy Angelakos @vyruss.org · 08/09/2026

Gianni Ciolli and Afroditi Loukidou explain why it's important to reproduce #PostgreSQL production environments with automation at @pgday.uk #pgdayuk

Gianni Ciolli and Afroditi Loukidou on stage at PGDay UK

011

Jimmy Angelakos @vyruss.org · 08/09/2026

Divya Sharma explaining PostgreSQL configuration parameters at @pgday.uk #pgdayuk

002

Jimmy Angelakos @vyruss.org · 02/09/2026

All right, so you inherited bad database. Improper encodings, 100-column tables, missing indexes, a huge temp_1 table nobody remembers creating. The recording of my July LinkedIn Live on inheriting a bad #PostgreSQL #database is now up. vyruss.org/blog/linkedi... #Postgres @manning.com

Jimmy Angelakos on LinkedIn Live. Bold caption "ALL RIGHT, SO YOU INHERITED A BAD DATABASE..." with old computers and Tux the Linux penguin in the background of his office.

131

Jimmy Angelakos @vyruss.org · 02/09/2026

#Postgres is 30 this year. Getting started is still too hard. Developer, educator, student, beginner? Come tell us how we fix that. Training Materials WG, @pgconf.eu Community Events Day, 23 Oct: 👇 2026.pgconf.eu/community-ev... #pgconfeu #postgresql

PostgreSQL Conference Europe, Valencia, 20–23 October 2026 — Community Events Day PostgreSQL Training Materials Working Group graphic showing stepping stones across a river connecting the labels "Never used a database" and "Ships with Postgres"

000

Jimmy Angelakos @vyruss.org · 01/09/2026

Real code: Connect to the database -> succeed/fail. Run 100 tasks, or don't. Clanker code: Database connectivity is lazy. When the app needs to connect, send a lightweight probe. If it succeeds, allocate a massive connection pool for 100 tasks. If it fails, skip over every single one of the tasks.

$db, err := database.Connect() if err != nil { log.Fatal("Failed to connect.") } for _, task := range tasks { go process(db, task) }$

100

Jimmy Angelakos @vyruss.org · 31/08/2026

On Tuesday 8th Sept, I'll be speaking at 🇬🇧 @pgday.uk about rebuilding a major piece of #PostgreSQL #backup infrastructure from scratch! Don't miss this great event in #London, use discount code JIMMY20 at 2026.pgday.uk, CU there! 🐘🔥 #Postgres #Conference #OpenSource #DisasterRecovery

PGDay UK 2026 London poster for a talk titled "100,000 Lines of C Later: Re-architecting Enterprise Postgres Backups in Go," scheduled 14:40–15:30 on Tuesday 8 September 2026 at Cavendish Conference Centre, showing event branding and a speaker portrait of Jimmy Angelakos.

021

Jimmy Angelakos @vyruss.org · 10/08/2026

Thank you so much for 1040 subscribers! All my recorded PostgreSQL content goes up on the YouTube channel: ⏯️ youtube.com/JimmyAngelakos #Postgres #PostgreSQL #YouTube #OpenSource #Database #SQL #Developer

150

Jimmy Angelakos @vyruss.org · 27/07/2026

Probably the best-sounding vinyl I have, from 1979 😉👌 What a record from YMO! #YMO #Vinyl #YellowMagicOrchestra

The vinyl record sleeve for Yellow Magic Orchestra's album Solid State Survivor on top of a Hitachi turntable. An orange obi strip with Japanese text is attached along the left edge of the sleeve.

020

Jimmy Angelakos @vyruss.org · 22/07/2026

$AI_COMPANY said the $ROGUE_INCIDENT was an "unprecedented anomaly" caused by $UNFORTUNATE_CIRCUMSTANCES, assuring users they are robustly reinforcing their guardrails. #ThisIsOurLifeNow #NewsAt11 #WorkingAsIntended #ThisIsFine #AI

A female customer service representative wearing a headset and a blazer, looking directly head-on at the camera, with a frozen smile.

000

Jimmy Angelakos @vyruss.org · 16/07/2026

Have you ever wanted to converse with a #book? You can't, but the next best thing is having the author explain it to you live. Join me tomorrow at 10am ET/3pm BST on LinkedIn Live and find out what to do when a bad #database lands in your vicinity. 🔗 hubs.la/Q04pGkS_0 #PostgreSQL #Postgres

020

Jimmy Angelakos @vyruss.org · 14/07/2026

Most bad SQL never throws an error. It just returns the wrong result, or runs far slower than it should, and slips straight through code review into production. The recording of my April LinkedIn Live on fixing bad SQL in #PostgreSQL is now up. vyruss.org/blog/linkedi...

LinkedIn Live: Fixing Bad SQL in PostgreSQL with Jimmy Angelakos

011

Jimmy Angelakos @vyruss.org · 14/07/2026

I was recently interviewed and quoted in The Read Replica regarding #PostgreSQL issues in production. www.thereadreplica.com/news/agent-w... #Postgres #Database

A promotional graphic from "The Read Replica by Supabase" featuring Jimmy Angelakos, Staff Software Engineer @ pgEdge. The graphic displays the quote: "YOU DISCOVER UNDER REAL WORLD CONDITIONS WITH INCREASED USAGE THAT THINGS ARE NOT WHAT YOU THOUGHT THEY WERE."

020

Jimmy Angelakos @vyruss.org · 14/07/2026

Taking over a chaotic database is stressful, but it doesn't have to be a nightmare 😵‍💫. Let's map out how to assess it & target improvements! 🛟 🗓️ Fri, Jul 17 | 10am ET/3pm BST Grab your spot: www.linkedin.com/events/whatt... #PostgreSQL #Postgres #Database #OpenSource #Book

071

Jimmy Angelakos @vyruss.org · 08/07/2026

🚨 Deal of the Day July 8th 🚨 Mistakes...and how to avoid them! HALF OFF my book PostgreSQL Mistakes and How to Avoid Them and other selected titles @manning.com: hubs.la/Q03Nc0hv0 #Postgres #PostgreSQL #TechBooks #Sale #Books

Promotional graphic from Manning Publications for July 8th titled "Mistakes...and how to avoid them!". Text reads: "Discover the errors, pitfalls, and screw ups developers often fall into...and how you can avoid them yourself!". The image displays four book covers on a green background: 100 C++ Mistakes, 100 Go Mistakes, 100 Java Mistakes, and 100 SQL Server Mistakes.

110

Jimmy Angelakos @vyruss.org · 01/07/2026

@manning.com's Independence Day #Sale is live (July 1-5)! 🎆 New deals unlock and stack daily: July 1: 50% off eBooks July 2: +50% off Print July 3: +$10 liveProjects/Videos July 4: +$199.99 Pro Sub July 5: +20% off Teams Grab a copy of #PostgreSQL Mistakes and How to Avoid Them: hubs.la/Q03Nc0hv0

020

Jimmy Angelakos @vyruss.org · 05/06/2026

Shaun Thomas shows how easy (?) it is to create a #PostgreSQL extension at PG DATA 2026! #Postgres #PGDATA2026 #extensions #OpenSource #Database

050

Jimmy Angelakos @vyruss.org · 04/06/2026

Nida Fatima now presenting how to work with graph-like data in #Postgres, at PG DATA 2026 #Chicago! #PostgreSQL #OpenSource #GraphDatabase #PGData2026

050

Jimmy Angelakos @vyruss.org · 01/06/2026

Speaking this Friday at @pg-data.bsky.social #Chicago! Join me to explore yet another PostgreSQL Mistake 😉: how LISTEN/NOTIFY can trigger locks & timeouts at scale, and how to fix it. 🎟️ 50% off code ANGELAKOS50: 2026.pg-data.org #PostgreSQL #PGData #PGData2026 #Postgres #OpenSource #Database

0101

Jimmy Angelakos @vyruss.org · 22/05/2026

Yesterday I delivered a Lightning Talk at #PGConfdev on a surprising #PostgreSQL misstep. Luckily, my book PostgreSQL Mistakes and How to Avoid Them is included in the @manning.com Memorial Day sale so you can get it for 50% off until May 25th!😉 👇 hubs.la/Q03Hcbkj0 #Books #Sale #TechBooks #Postgres

Memorial Day sale May 21st-25th Half Off - PostgreSQL Mistakes and How to Avoid Them

010

Jimmy Angelakos @vyruss.org · 21/05/2026

Good morning with one more statistic from our @pgconf.dev session 2026.pgconf.dev/session/635 — thanks to Tom Lane for suggesting this query: Do contributors return (based on whether they got any patches accepted or not)? #PostgreSQL #Postgres #Dev #Development #PGConfdev

(Chart) PostgreSQL commitfests: do new patch authors come back? 72% who got a patch committed returned later, 31% who never got a patch in ever returned later

010

Jimmy Angelakos @vyruss.org · 19/05/2026

Tue @pgconf.dev: ・ Beyond the source: the human architecture of #PostgreSQL— @floord.bsky.social, H.Kiran, M.Zhou, V.Kaplan & I 2026.pgconf.dev/session/558 ・ Estab. the PostgreSQL standard: What's #Postgres compatible?— hettied.bsky.social, I & hopefully you 2026.pgconf.dev/session/450 #PGConfdev

020

Jimmy Angelakos @vyruss.org · 17/05/2026

1000 subscribers! Thank you so much 🙏 Pure YouTube Postgres content ❤️🐘. No AI slop. youtube.com/JimmyAngelakos

Screenshot of JimmyAngelakos YouTube channel showing 1000 subscribers

000

Jimmy Angelakos @vyruss.org · 15/05/2026

I'll be at @pgconf.dev doing things! • Beyond the source: the human architecture of #PostgreSQL (Panel) • Establishing the PostgreSQL standard: What's #Postgres compatible? (Community Discussion) • PostgreSQL Commitfest Metrics: A Quantitative Analysis (Talk) 2026.pgconf.dev/schedule #PGConfdev

020

Jimmy Angelakos @vyruss.org · 11/05/2026

I didn't have Ricart-Agrawala on my bingo card for Monday morning but here we are #DistributedSystems (Mandatory #AIslop included for our LinkedIn readers)

An abstract, futuristic digital illustration representing a complex network or algorithm. On the left, a grid of dark, textured panels features glowing cyan geometric and circuit-like symbols. One prominent square glows brightly in orange with a dense circuit board pattern, emitting a horizontal beam of light to the right. This beam connects to a luminous, multi-layered wireframe structure resembling a glowing cyan and orange sphere and hexagon. A complex web of interconnected nodes, lines, and radiating orange arrows surrounds this central structure, set against a dark background with subtle circuitry patterns.

010

Jimmy Angelakos @vyruss.org · 02/04/2026

Tomorrow! Live session: Fixing Bad SQL in PostgreSQL. (10am ET/3pm BST) 👇 linkedin.com/events/74433... #PostgreSQL #Postgres #OpenSource #Database #SQL

Linkedin LIVE: Jimmy Angelakos - cover of PostgreSQL Mistakes and How to Avoid Them

010

Jimmy Angelakos @vyruss.org · 30/03/2026

If you're interested in #PostgreSQL, make sure you attend my April 3rd LinkedIn Live event (10am ET/3pm BST)! I'll break down real #SQL anti-patterns from my book (via @manning.com) and fix them live. 👇 🎟️ Register: linkedin.com/events/74433... 📖 Book: hubs.la/Q03Nc0hv0 #Postgres #webinar

LinkedIn LIVE: Jimmy Angelakos - PostgreSQL Mistakes and How to Avoid Them

021

Jimmy Angelakos @vyruss.org · 25/03/2026

–How much salmiakki do you need? –Yes #Helsinki #NordicPGDay

Several bags of salty licorice candies from Finland. In the top row, from left to right, are a black bag of Salty Bombs from Secret of Salty Licorice, a yellow and black bag of Pantteri Original, and a blue bag of Tyrkisk Peber Original. In the middle row, from left to right, are a black bag of Lemon Salmiac from Secret of Salty Licorice, a red and black bag of TV Mix Salmiakki, and a yellow bag of Tyrkisk Peber Pepper Licorice. In the bottom row, from left to right, are a blue and yellow bag of Tyrkisk Peber Hot & Sour and a black bag of Tar Salmiac from Secret of Salty Licorice.

000

Jimmy Angelakos @vyruss.org · 22/03/2026

Absolutely thrilled that Suresh found "PostgreSQL Mistakes and How to Avoid Them" a useful learning resource! 🚀🐘 For anyone interested in the book version, you can grab a copy from @manning.com here: hubs.la/Q03Nc0hv0 📖 #PostgreSQL #Postgres #Books #Database

Suresh Kumar Bandaru
Student at BTH | Enthusiast in Cloud Computing and Artificial Inte...

I’m happy to share that I’ve completed the video course 📺 "PostgreSQL Mistakes and How to Avoid Them", which lasts 6 hours and 4 minutes. 📚 by Jimmy Angelakos published by Manning Publications Co. and available on O'Reilly platform. ✨

A huge thank you to the author for such an insightful resource! I thoroughly enjoyed the 11 chapters 📖. This is an excellent book that provides numerous examples and I learned how to avoid and diagnose database configuration and operation issues, fix a poorly designed database, and maximize PostgreSQL performance. It also includes causes of errors with associated code examples for the psycopg (Python DB API).

In particular, the resources in Appendix A, Appendix B, and the GitHub repository (https://lnkd.in/g-VafvfH) are extremely helpful for creating the Frogge Emporium database from scratch.

Additionally, the author also provided a lot of dynamic customer test data dumps to help explore the various examples presented in the textbook.

(Note: The image also contains a screenshot at the bottom showing the O'Reilly "Your History" page with the course "PostgreSQL Mistakes and How to Avoid Them, Video Edition" marked as 100% Progress).

140

Jimmy Angelakos @vyruss.org · 10/03/2026

To celebrate SCaLE 23x (@socallinuxexpo.bsky.social), I’m giving away 5 digital copies of my book, PostgreSQL Mistakes and How to Avoid Them (published by @manning.com). Enter the giveaway below! 👇 kingsumo.com/g/3l5ron1/po... #SCaLE23x #Giveaway #PostgreSQL #Postgres #Books #OpenSource #Database

Jimmy Angelakos sez hi in front of SCaLE at the Pasadena Convention Center

Book cover of PostgreSQL Mistakes and How to Avoid Them by Jimmy Angelakos

030

Jimmy Angelakos @vyruss.org · 09/03/2026

What better way to close SCaLE 23x than with a Drum and Bass night at Old Towne Pub Pasadena? #SCaLE23x

DJ and people dancing at dimly lit DnB night at Old Towne Pub Pasadena

020

Jimmy Angelakos @vyruss.org · 08/03/2026

Doug Comer SCaLE 23x closing keynote www.socallinuxexpo.org/scale/23x/pr... #SCaLE23x

020

Jimmy Angelakos @vyruss.org · 08/03/2026

Peter Farkas, CEO @ Percona "Enterprises Play Dirty" at SCaLE 23x on how companies use/abuse "Open Source" and other dirty tricks they employ. www.socallinuxexpo.org/scale/23x/pr... #SCaLE23x #OpenSource

020

Jimmy Angelakos @vyruss.org · 07/03/2026

Hettie Dombrovskaya "PostgreSQL and Academia: Establishing Partnership" at @socallinuxexpo.bsky.social Livestream 👉 www.youtube.com/live/yu1bCao... #PostgreSQL #Postgres #Academia #OpenSource #SCaLE23x #Database

Hettie Dombrovskaya on stage at SCaLE 23x

131

Jimmy Angelakos @vyruss.org · 07/03/2026

Slides from my talk CloudNativePG: Robust, Self-Healing PostgreSQL on Kubernetes at SCaLE 23x → vyruss.org/computing/sl... #CloudNativePG #SCaLE23x #Postgres #PostgreSQL #Kubernetes #K8s #CloudNative #Database #OpenSource

Title slide: CloudNativePG: Robust, Self-Healing PostgreSQL on Kubernetes

021

Jimmy Angelakos @vyruss.org · 05/03/2026

Nick Meyer and Practical PgBouncer Pain Prevention – #PostgreSQL @ SCaLE live now! www.socallinuxexpo.org/scale/23x/pr... #Postgres #OpenSource #Database #SCaLE23x

040

Jimmy Angelakos @vyruss.org · 01/03/2026

Next Friday at @socallinuxexpo.bsky.social, I'll show you how the @cloudnativepg.bsky.social operator makes running #PostgreSQL on #Kubernetes incredibly easy. Come hear me at #SCaLE23x (SPK23 for 50% off) or catch the live stream online! 🐘☸️☁️ www.socallinuxexpo.org/scale/23x/pr... #K8s #Postgres

Speaking at SCaLE! JIMMY ANGELAKOS
PostgreSQL:
CloudNativePG: Robust, Self-Healing PostgreSQL on Kubernetes
SCaLE23x socallinuxexpo.org

010

Jimmy Angelakos @vyruss.org · 26/02/2026

1. Tomato = umami 2. Coffee = delicious 3. ???? 4. PROFIT! #MadScientist

A cup of espresso with a spoon on the saucer

110

Jimmy Angelakos @vyruss.org · 18/02/2026

M83's Outro must be the most overused piece of music of all time. I'm so happy for you, M83, but please let's now all agree to burn it with fire. *runs through wheat field while drone soars above* #Music #M83 #Outro #Cliche #PleaseStop

A cinematic drone shot of a person running away from the camera through a vast field of golden wheat. They are running toward a dramatic landscape featuring a massive fjord and towering mountains under a moody sky.

000

Jimmy Angelakos @vyruss.org · 12/02/2026

TONIGHT: @PostgresEDI.bsky.social #PostgreSQL Edinburgh Meetup — Alastair Turner (Percona) dives into #HA & failover. Sean Hammond shares a "story from the trenches" on syncing #Postgres to Elasticsearch. 📍 Lister Learning & Teaching Centre, U of #Edinburgh ⏰ 18:00 🎟️ luma.com/uj0qvxqk #TechMeetups

Lister Learning & Teaching Centre at the University of Edinburgh

000