Sign in

Jimmy Angelakos

@vyruss.org
187 followers 192 following 247 posts

Peace, Love & Linux. Strictly personal opinions. #PostgreSQL Significant Contributor & speaker. Author of PostgreSQL Mistakes and How to Avoid Them: hubs.la/Q03Nc0hv0 Co-author of the PostgreSQL 16 Administration Cookbook: packt.link/6PurB

PostsRepliesMedia
Jimmy Angelakos @vyruss.org · 7h
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
ICEBERG Meetup Europe event flyer showing the ICEBERG logo and title, date and time "Oct 8th | 17:00–21:00" in London, and co-host logos and names: Fresha, Databricks, and Lakekeeper (created by Vakamo).
010
Jimmy Angelakos @vyruss.org · 7h
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.
011
Jimmy Angelakos @vyruss.org · 28/09/2026
Huge news. A deep bow to my @pgedge.bsky.social colleagues who worked so hard to build by far the easiest and cleanest #Postgres platform out there. It's not a #dev toy: the database you prototype on can go straight into production. The feature list is incredible, and what's next is even better. 👏
100
Jimmy Angelakos @vyruss.org · 26/09/2026
I just invented the term "Jet2 parenting" #iykyk
000
Reposted by Jimmy Angelakos
PostgresEDI @postgresedi.bsky.social · 24/09/2026
Tonight! PostgreSQL Edinburgh September meetup, with talks by @danielroe.dev and @vyruss.org! 🔽 cloomba.com/e/postgresed... #PostgreSQL #Postgres #Edinburgh #Scotland #Meetup
cloomba.com
PostgreSQL Edinburgh Meetup September 2026
Be part of our Edinburgh PostgreSQL Meetup! Join the PostgreSQL Edinburgh organisers and fellow PostgreSQL enthusiasts at Room 1.27, Paterson's Land, University of Edinburgh! Connect with peers (all l...
082
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 · 15/09/2026
New Blog Post: PostgreSQL Commitfest Metrics: PGConf.dev 2026 Part One vyruss.org/blog/postgre... #PostgreSQL #Postgres #OpenSource #Database #PGConfDEV
vyruss.org
PostgreSQL Commitfest Metrics: PGConf.dev 2026 Part One
A belated recap of my first PGConf.dev, in Vancouver, where Andreas Scherbaum and I presented a quantitative analysis of twelve years of commitfests: what happens to a patch after somebody sends it…
020
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 · 09/09/2026
Yesterday at @pgday.uk I talked about #pgSafe, a from-scratch Go rewrite of enterprise #Postgres backups, and what #pgBackRest's near-demise taught us: what a backup tool really does, the invariants it must uphold, and where 100,000 lines of C went. vyruss.org/blog/100000-... #PostgreSQL #OpenSource
vyruss.org
100,000 Lines of C Later: pgSafe at PGDay UK 2026
Yesterday I gave a talk at PGDay UK 2026 in London about pgSafe, a from-scratch Go rewrite of enterprise Postgres backups, and what pgBackRest's near-demise in April taught us. The talk covered what…
020
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 UKAfroditi Loukidou on stage at PGDay UK
011
Jimmy Angelakos @vyruss.org · 08/09/2026
Divya Sharma explaining PostgreSQL configuration parameters at @pgday.uk #pgdayuk
Divya Sharma on stage at PGDay UK
002
Jimmy Angelakos @vyruss.org · 07/09/2026
Tomorrow! ⬇️
010
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
Reposted by Jimmy Angelakos
FOSDEM @fosdem.org · 30/08/2026
fosdem.org
FOSDEM 2027 will take place on 30 & 31 January 2027 — FOSDEM 2027
FOSDEM 2027 will take place on Saturday 30 and Sunday 31 January 2027, at the ULB Solbosch campus in Brussels, Belgium.
05624
Reposted by Jimmy Angelakos
pgEdge Postgres @pgedge.bsky.social · 21/08/2026
@vyruss.org shipped pg_statviz 1.2 with #PostgreSQL 19 support. New: blocking locks module (pg_blocking_pids(), soft blocks included), #OpenAI provider alongside #Anthropic & #Google. Zero external dependencies. AI analysis fully opt-in. 👉 vyruss.org/blog/pg_stat... #OpenSource #Database #Stats
vyruss.org
pg_statviz 1.2 released with PostgreSQL 19 support and new features
Extension pg_statviz for time series analysis & visualization of Postgres internal statistics has released version 1.2 with PostgreSQL 19 support, a new blocking locks analysis module, and an OpenAI-c...
021
Jimmy Angelakos @vyruss.org · 20/08/2026
New Blog Post: pg_statviz 1.2 is out, with PostgreSQL 19 support, a new blocking locks module, and an AI provider for OpenAI API: vyruss.org/blog/pg_stat... #PostgreSQL #Postgres #extension #pg_statviz #database #stats #statistics #visualization
vyruss.org
pg_statviz 1.2 released with PostgreSQL 19 support and new features
Extension pg_statviz for time series analysis & visualization of Postgres internal statistics has released version 1.2 with PostgreSQL 19 support, a new blocking locks analysis module, and an…
010
Jimmy Angelakos @vyruss.org · 19/08/2026
In 2 hours' time (11am EDT) Antony Pegg will be hosting our #ColdFront webinar! Tired of data-lake-y buzzwords? Come hear me and my colleagues present a fresh perspective and see a live demo by the brilliant Paul Rothrock! Register 👇 us02web.zoom.us/webinar/regi... #PostgreSQL #Postgres #LakeHouse
120
Jimmy Angelakos @vyruss.org · 12/08/2026
#NoContextClaude
Cropped screenshot, Claude's response reads "You were right to stop me".
000
Jimmy Angelakos @vyruss.org · 11/08/2026
This Thursday: #PostgreSQL #Edinburgh #meetup! Torsten Förtsch on logical replication (escape the cloud, own your data) + Paolo Guagliardo on why SQL's infamous NULL is broken and how #Postgres can fix it. Pizza 6pm → talks → pub. All levels welcome! cloomba.com/e/postgresql...
cloomba.com
PostgreSQL Edinburgh Meetup August 2026
Be part of our Edinburgh PostgreSQL Meetup! Join the PostgreSQL Edinburgh organisers and fellow PostgreSQL enthusiasts at Room LG45, Paterson's Land, University of Edinburgh! Connect with peers (all…
011
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
A photo close-up of an Atari 1040STE's logo badge
150
Reposted by Jimmy Angelakos
Dan Neidle @danneidle.bsky.social · 26/07/2026
Scotland raised its top income tax rate to 48% to make the rich pay more. New HMRC data suggests the result may have been the opposite: Scotland collected about £22m less. We can't be sure, but Scotland may have fallen over the Laffer curve. 🧵:
2112547
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 · 20/07/2026
Great #InfoSec and #KnowledgeSharing blog post by Athanasios Kostopoulos on asking masters of their craft one question: "Share the top 3 resources for your domain of expertise." Fellow IT professionals, what would your top 3 resources be in your area of expertise? akostopoulos.blog/2026/07/20/w...
akostopoulos.blog
What are your top three resources?
Sometimes I get lucky and get access to certain people that I consider exceptional masters of their craft. If you have one question and you need to make it count, what would this question be? The o…
020
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
Promotional graphic for a live stream featuring a headshot of author Jimmy Angelakos alongside the cover of his book, 'PostgreSQL Mistakes and How to Avoid Them' by Manning Publications. A red 'LIVE' badge is in the top left corner.
020
Jimmy Angelakos @vyruss.org · 15/07/2026
New blog post: #PostgreSQL's LISTEN/NOTIFY is elegant and lightweight. It can also quietly bring a busy database to its knees. In my #POSETTE and PG DATA talk I dig into a real production incident and the fix that got us out of it. vyruss.org/blog/listen-... #Postgres #PGDATA2026 #POSETTEconf
vyruss.org
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.
000
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
Reposted by Jimmy Angelakos
POSETTE: An Event for Postgres @posetteconf.com · 14/07/2026
LISTEN/NOTIFY is elegant—but NOTIFY takes a cluster-wide exclusive lock that can cause timeouts under high concurrency. In Jimmy Angelakos’ @vyruss.org POSETTE 2026 talk you'll learn about this feature, its risks, & how to mitigate them. 📺Watch now: www.youtube.com/watch?v=gVsU... #PosetteConf
011
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
Promotional graphic for a live stream featuring a headshot of author Jimmy Angelakos alongside the cover of his book, 'PostgreSQL Mistakes and How to Avoid Them' by Manning Publications. A red 'LIVE' badge is in the top left corner.
071
Jimmy Angelakos @vyruss.org · 13/07/2026
A recap of our @PostgresEDI 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 vyruss.org/blog/postgre... #PostgreSQL #Postgres #Edinburgh #OpenSource #TechMeetups #Database
vyruss.org
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.
052
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 · 07/07/2026
Only 2 days to the Edinburgh #PostgreSQL meetup with @postgresedi.bsky.social! Join our local #community for pizza, networking & great talks by Pat Wright on tech speaking for introverts & Martins Otun on #AI retrieval w/pgvector in regulated industries RSVP here: lu.ma/ocnyugns #Meetups #Postgres
lu.ma
PostgreSQL Edinburgh Meetup July 2026 · Luma
Be part of our Edinburgh PostgreSQL Meetup! Join the PostgreSQL Edinburgh organisers and fellow PostgreSQL enthusiasts at Room 1.37, Paterson's Land,…
021
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
A promotional graphic for Manning's Independence Day sale from July 1st to 5th. The left side features stacked red banners listing the daily deals: 20% Off Team Subscription, $199 Annual Pro Subscription, Half Off ALL eBooks!, Half Off ALL Books!, and All LiveProjects and LiveVideos JUST $10! The Manning logo and red, white, and blue paper fans are at the bottom. The right side displays four book covers: "Build a DeepSeek Model," "Build a Multi-Agent System," "Build an Advanced RAG Application," and "Build an AI Agent."
020
Reposted by Jimmy Angelakos
PostgreSQL @postgresql.org · 26/06/2026
News: pgEdge Announces ColdFront for PostgreSQL, Seamlessly Uniting AI, Analytical and OLTP Workloads www.postgresql.org/about/news/pgedg… #postgresql
011
Jimmy Angelakos @vyruss.org · 26/06/2026
"High-functioning" often just means your struggles don't inconvenience others. It involves a dangerous magic trick: cannibalizing your personal life to fuel #success at #work. It's an unsustainable trade-off and reality finally catches up in the form of burnout #AuDHD #Autism #ADHD #Neurodiversity
061
Reposted by Jimmy Angelakos
PostgresEDI @postgresedi.bsky.social · 26/06/2026
Our next meetup is Thurs 9th July! We have two fantastic talks. Doors and pizza from 6pm. Talks from 7pm. - Pat Wright. Speaking and Community Involvement for the Introvert - Martins Otun. Traceable, SQL-First Retrieval for Compliance-Critical Systems luma.com/ocnyugns #Edinburgh #PostgreSQL
luma.com
PostgreSQL Edinburgh Meetup July 2026 · Luma
Be part of our Edinburgh PostgreSQL Meetup! Join the PostgreSQL Edinburgh organisers and fellow PostgreSQL enthusiasts at Room 1.37, Paterson's Land,…
011
Jimmy Angelakos @vyruss.org · 18/06/2026
Proud to share what I've been building: #pgEdge ColdFront is live. ​Moving #PostgreSQL data to #S3 while keeping it queryable & updatable as if local, without app code changes, is exactly the hard problem I enjoy. ​Under the hood: hubs.la/Q04lS0fb0 #Postgres #Analytics #LLM #AI #ApacheIceberg
hubs.la
Introducing ColdFront: Seamlessly Uniting OLTP, Analytics and AI Workloads on PostgreSQL
Transparent PostgreSQL data tiering for OLTP, analytics, and AI workloads. Cold data stays fully writable - no application changes, no SQL rewrites required.
020
Reposted by Jimmy Angelakos
POSETTE: An Event for Postgres @posetteconf.com · 18/06/2026
Next at #PosetteConf Livestream 4 (18 Jun): Jimmy Angelakos @vyruss.org (PostgreSQL contributor) presents "LISTEN Carefully: How NOTIFY Can Trip Up Your Database" and why NOTIFY can cause timeouts. Join live to chat with Jimmy in the virtual hallway track on Discord. posetteconf.com
Person seated near a window with glass cabinets in the background, facing the camera, framed by “POSETTE: An Event for Postgres 2026.”
021
Reposted by Jimmy Angelakos
PostgresEDI @postgresedi.bsky.social · 10/06/2026
Tomorrow’s the day. Come prepared with any issues that you’re having with Postgres and we’ll try to find solutions as a group.
021
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
Shaun Thomas on stage at PG DATA
050
Jimmy Angelakos @vyruss.org · 04/06/2026
Henrietta Dombrovskaya @hettied.bsky.social talking #Postgres #security at PG DATA 2026! #PostgreSQL #OpenSource #Database #PGData2026
Henrietta Dombrovskaya on stage at PG DATA
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
Nida Fatima on stage at PG DATA 2026
050
Jimmy Angelakos @vyruss.org · 04/06/2026
@PG-DATA.bsky.social #Chicago kicking off! #PGData2026 #PostgreSQL #Postgres #OpenSource #Database #Conference
Henrietta Dombrovskaya kicking off PG DATA 2026 in the plenary room
070
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
Promo for PG DATA 2026 featuring a headshot of speaker Jimmy Angelakos. The text announces his talk, "LISTEN Carefully: How NOTIFY Can Trip Up Your Database," scheduled for Friday, June 5, from 10:25 AM to 10:50 AM in Room 1 at the Loyola University Water Tower Campus in Chicago.
0101