iiinova — where your digital self keeps evolving

Pavlo Golub @pavlogolub.bsky.social · 13m

Domain 5 of the Open Alliance for PostgreSQL Education DBA-1 certification, all 8 exam topics in one video: the postmaster, background workers, client backends, shared buffers, work_mem & maintenance_work_mem, how dirty buffers reach disk, what WAL is, and WAL buffer and writer youtu.be/BHlPTG4lmow

youtu.be

PostgreSQL DBA-1: Domain 5 — Server Architecture & Background Processes (all 8 exam topics)

YouTube video by PAVLOG

000

Pavlo Golub @pavlogolub.bsky.social · 29/09/2026

Domain 1 of the Open Alliance for #PostgreSQL Education DBA-1 certification explained! All 14 exam topics in one video: how Postgres gets installed, where it lives on disk, how it's configured and secured, and how it's run and upgraded youtu.be/iIyFH8HSZEA

youtu.be

PostgreSQL DBA-1: Domain 1 — Installation, Versioning & Basic Configuration (all 14 exam topics)

YouTube video by PAVLOG

032

Pavlo Golub @pavlogolub.bsky.social · 19/09/2026

@gopherconeu.bsky.social is the any CfP for the upcoming event in Berlin?

000

Pavlo Golub @pavlogolub.bsky.social · 08/09/2026

pgwatch v6 ships Patroni overview dashboard. It could not have existed before - and working out why explains the whole feature. The dashboard asks for 22 readings. #Postgres does not know any of these. #Patroni does, on its own metrics endpoint - and until v6, #pgwatch had no way to read it.

110

Pavlo Golub @pavlogolub.bsky.social · 07/09/2026

pgwatch v6 is out in beta, and its three headline changes are all the same move: stop running one of everything. Check how 435 goroutines became 28! youtube.com/shorts/Uyk8A... #postgreSQL #monitoring

youtube.com

pgwatch v6: 435 goroutines became 28 #postgresql #monitoring

YouTube video by PAVLOG

000

Reposted by Pavlo Golub

CYBERTEC PostgreSQL @cybertec-official.bsky.social · 31/08/2026

We're back with @pavlogolub.bsky.social for another conference vlog, this time from Swiss PGDay 2026 in Rapperswil. Follow our vlog playlist on YouTube so you catch the next one. 🐘 youtube.com/playlist?lis...

001

Pavlo Golub @pavlogolub.bsky.social · 26/08/2026

#Linux was released just one day after Ukraine regained its independence from Soviet Union! A coincidence? I don't think so! 😉💙💛 On August 25, 1991, a 21-year-old student sent a message to a Usenet newsgroup. He thought he was just building something fun for himself.

010

Pavlo Golub @pavlogolub.bsky.social · 17/08/2026

Also shipped: React 19 WebUI, randomized JWT secrets (bye hardcoded keys 👋), deadlock fixes, graceful sink-outage handling, and Postgres bumped to v19. It's a beta — try it, break it, tell us: github.com/cybertec-pos...

github.com

Release v6.0.0-beta · cybertec-postgresql/pgwatch

pgwatch v6-beta is here 🎉 The biggest release since v5 — full Postgres v19 support, a new source type, fully modernized dashboards, and a reaper core built for reliability at scale. The big three 🔌...

010

Pavlo Golub @pavlogolub.bsky.social · 17/08/2026

New metrics you asked for: recovery, stat_lock, settings_num, autovacuum_scores, mem_exceeded_count, wal_fpi_bytes, plus stats_reset across tables/indexes/sprocs. Real production pain points → real fixes.

100

Pavlo Golub @pavlogolub.bsky.social · 17/08/2026

🎉 pgwatch v6-beta is out! The biggest release yet: 🔌 Prometheus exporters as a native source 📊 All dashboards rebuilt on Grafana v13 ⚙️ Reaper core rebuilt for parallel, bounded-context collection A monitoring stack that scales with you 🐘 github.com/cybertec-pos...

github.com

Release v6.0.0-beta · cybertec-postgresql/pgwatch

120

Pavlo Golub @pavlogolub.bsky.social · 03/08/2026

Flew to Türkiye for the very first PG Istanbul Meetup! 🇹🇷🐘 Presented my talk, hung out on the roof, crossed the Bosphorus, tasted top-tier doner, and drank way too much tea. Skip the WAL, watch the raw #UNLOGGED cut: youtu.be/XUMb1z3sC8o Show up at a local #PostgreSQL meetup near you! 🚀 #PAVLOG

youtu.be

Postgres Istanbul Meetup #1 [UNLOGGED]

YouTube video by PAVLOG

010

Pavlo Golub @pavlogolub.bsky.social · 31/07/2026

While the official documentary compiles, the raw [#UNLOGGED] cut from #WAWTech+Summer 2026 is live. 🚀 Open-air tech festival vibes at Tor Służewiec, staffing the #Postgres booth, and talking AI-powered beer recommendations! Watch the full drop here: youtu.be/aAGHtQF77r0#...

youtu.be

WAWTech+Summer 2026 [UNLOGGED]

YouTube video by PAVLOG

000

Pavlo Golub @pavlogolub.bsky.social · 28/07/2026

#PAVLOG is back! Now from #Chicago and PG DATA 2026! Join me to the atmosphere of summer blues! Special guest stars Hettie Dombrovskaya, Pat Wright, Carlos A Aranibar! Devrim Gündüz as "Dancing King", and many other cool people! Please tag everyone I forgot in replies! #postgres youtu.be/3AtLTvifldY

youtu.be

PG DATA 2026 in Chicago: A PostgreSQL Conference Vlog with Pavlo Golub | CYBERTEC

YouTube video by CYBERTEC - PostgreSQL Services & Support

021

Pavlo Golub @pavlogolub.bsky.social · 22/07/2026

#WAWTech +Summer was wild! Hear the story first! A regular attendee approached to #PostgreSQL booth and asked if he is allowed to wear Slonik costume. We agreed, so the guy was running all over the conference wearing elephant and promoting our booth! 🙂🏃‍♂️‍➡️🚨 youtu.be/ijzNanI3Nxo

youtu.be

WAWTech attendee wearing Postgres mascot

YouTube video by PAVLOG

010

Pavlo Golub @pavlogolub.bsky.social · 17/07/2026

🚀 Registration is OPEN for the PGConf.PL 2026! Be part of history at the very first Polish PostgreSQL community conference this November in Gdańsk. 💰 Use code COMETOGDANSK right now to get 14% off your ticket. ❣️ Register today to secure your spot! 2026.pgconf.pl/registration/ #postgresql

2026.pgconf.pl

Registration - PGConf.PL 2026

021

Pavlo Golub @pavlogolub.bsky.social · 11/07/2026

I'm dropping this as a test to see if you enjoy this faster, unedited format. Check it out and let me know if you want to see more of these!

000

Pavlo Golub @pavlogolub.bsky.social · 11/07/2026

In Postgres, an UNLOGGED table skips the write-ahead log for pure speed and zero crash recovery. That’s exactly what this first video is: a fast, uncompressed cut to capture the immediate, boots-on-the-ground vibe from Swiss PGDay 2026 while the team compiles the official documentary.

100

Pavlo Golub @pavlogolub.bsky.social · 11/07/2026

We at CYBERTEC usually spend a lot of time producing polished community documentaries, but sometimes you just want to push the raw data straight to the output. Welcome to the [UNLOGGED] experiment for Swiss PgDay 2026! youtu.be/fmXDeIODQ14 #PostgreSQL #SwissPGDay #PAVLOG

youtu.be

Swiss PgDay 2026 [UNLOGGED]

YouTube video by PAVLOG

100

Pavlo Golub @pavlogolub.bsky.social · 18/05/2026

One `sudo ip link delete` later, the portal loaded instantly. Choosing #Docker's default subnet for a public hotel WiFi is a personal attack on every developer in the building. Just... why? Because you can? :-D

110

Pavlo Golub @pavlogolub.bsky.social · 18/05/2026

After some digging, I found the culprit. It turns out a local Docker bridge on my machine had claimed the exact same 172.20.x.x subnet as the hotel. My laptop wasn't talking to the hotel router, but to itself in a virtual loop!

120

Pavlo Golub @pavlogolub.bsky.social · 18/05/2026

The captive portal refuses to load. No internet. I open the terminal and ping the router (172.20.0.1). Some of you may already be having second thoughts... ;-) The response time? 0.052 ms. Really?! Even though I love Canada🇨🇦, I won't believe any hotel lobby router is able to respond in 50 ms.

100

Pavlo Golub @pavlogolub.bsky.social · 18/05/2026

Ever had your own laptop gaslight you? 😅 Usually, my daily puzzles involve tuning #PostgreSQL, but today’s challenge was brought to you by hotel WiFi at PGConf.dev 🐘. Me: "I'm just going to quickly connect to the hotel WiFi to check emails." My Linux Laptop: "Absolutely not." 🔽

pgconf.dev

PGConf.dev 2026

PGConf.dev 2026 will be held on May 19–22 in Vancouver, BC to bring users, developers, and organizers together to advance PostgreSQL development.

100

Pavlo Golub @pavlogolub.bsky.social · 15/05/2026

I’m excited to share that pgxmock v5.1.0 has officially been released! If you are using pgx for PostgreSQL in Go, this library remains one of the best ways to build robust unit tests without needing a live database. github.com/pashagolub/p... #Golang #PostgreSQL #UnitTesting #OpenSource

github.com

Release v5.1.0 · pashagolub/pgxmock

What's Changed [+] add version policy by @pashagolub in #257 [+] bump actions/checkout from 4 to 6 by @dependabot[bot] in #252 [+] bump actions/setup-go from 5 to 6 by @dependabot[bot] in #255 [+]...

020

Pavlo Golub @pavlogolub.bsky.social · 06/05/2026

Two PGDay conferences. Two cities. One week. 🐘 I went from Helsinki to Paris in 48 hours and captured everything on camera…including a special cameo from Svitlana Lytvynenko. 👀 Episode 2 of the CYBERTEC Conference Vlog series is live! Read all about it: www.cybertec-postgresql.com/en/nordic-co...

cybertec-postgresql.com

Nordic Cool Meets Parisian Chic Vlog: Two PGDays, One Week

This blog talks about the vlog series and the episode showcasing the Nordic Pgday 2026 and pgDayParis. Read to know more.

030

Pavlo Golub @pavlogolub.bsky.social · 06/05/2026

Some details from the backstage. People helping out Cornelia Biacsics, Linda Leste, Isaac Alves. On the desk photo of Denys Holub and gifts from Volodymyr Katarovskyi, Josef Machytka, Elviie Abdulmennanova and Eugene Kuchansky. A complete set of magical items to attract good luck! 🔮💓

010

Pavlo Golub @pavlogolub.bsky.social · 06/05/2026

Lights, camera, Postgres! 🎬 Behind every 25-minute tech talk is a lot of coffee, a few retakes, and a very quiet house. Recording my POSETTE: An Event for Postgres talk was a great reminder of why I love this community.

182

Pavlo Golub @pavlogolub.bsky.social · 24/03/2026

There is a bad and a good being the first. Bad - you're the first, good - you're done early #speaking #pgdaynordic

000

Reposted by Pavlo Golub

pgDay Paris @pgday.paris · 16/03/2026

Come see Pavlo Golub (@pavlogolub.bsky.social) talk about "Customizing the Wordle Game Experience with PostgreSQL"! #PostgreSQL #conference #pgDayParis www.postgres...

001

Reposted by Pavlo Golub

pgDay Paris @pgday.paris · 28/02/2026

Come see Pavlo Golub (@pavlogolub.bsky.social) talk about "Customizing the Wordle Game Experience with PostgreSQL"! #PostgreSQL #pgDayParis #Conference www.postgres...

021

Pavlo Golub @pavlogolub.bsky.social · 14/02/2026

You can tell I'm older than 6! Thanks Elviie Abdulmennanova for the gift! 💙💛

010

Pavlo Golub @pavlogolub.bsky.social · 02/02/2026

PostgreSQL has successfully applied to 2026! List of accepted mentoring organizations will be published on February, 19th. Check here for more details on the program summerofcode.withgoogle.com #postgreSQL #gsoc #googlesummerofcode

summerofcode.withgoogle.com

Google Summer of Code

Google Summer of Code is a global program focused on bringing more developers into open source software development.

010

Pavlo Golub @pavlogolub.bsky.social · 10/12/2025

Second, it's the first time during a full-scale invasion that I've been able to meet with many Ukrainian IT fellows. Third, this is an opportunity to meet and inspire the local Polish Postgres community. We could start meetups next year, who knows!

010

Pavlo Golub @pavlogolub.bsky.social · 10/12/2025

I'm excited to speak at #WAWTECH for several reasons. First of all, it's not a #Postgres-specific conference, and I'm eager to hear exactly what the audience wants to hear from me.

120

Reposted by Pavlo Golub

Jimmy Angelakos @vyruss.org · 23/06/2025

AUTHOR UNBOXING: PostgreSQL Mistakes and How to Avoid Them! To celebrate the release of my book, you can use code PBAngelakos for 50% OFF until July 1st! youtube.com/shorts/zopxH... Order the book here @manningbooks.bsky.social 👉 mng.bz/D9mR #TechBooks #PostgreSQL #Postgres #OpenSource #Database

youtube.com

AUTHOR UNBOXING: PostgreSQL Mistakes and How to Avoid Them!

YouTube video by Jimmy Angelakos

1103

Pavlo Golub @pavlogolub.bsky.social · 20/06/2025

New #Golang GC implementation[1] is a wow! I see 20% less memory consumption during high loads with pgwatch[2] tests. It behaves fantastic with a lot of small objects created/freed! #greenteagc 1: github.com/golang/go/is... 2: github.com/cybertec-pos...

github.com

runtime: green tea garbage collector · Issue #73581 · golang/go

Green Tea 🍵 Garbage Collector Authors: Michael Knyszek, Austin Clements Updated: 2 May 2025 This issue tracks the design and implementation of the Green Tea garbage collector. As of the last update...

030

Pavlo Golub @pavlogolub.bsky.social · 12/05/2025

Another year, one more coin. Thanks everyone for your contributions to #postgresql! Not only people but all companies too, especially Cybertec!

PostgreSQL 17 release coin for all who contributed to the release

020

Pavlo Golub @pavlogolub.bsky.social · 25/03/2025

New golangci-linter issues cool warnings "QF1001: could apply De Morgan's law" I knew I'll use my university diploma one day! 😎

010

Reposted by Pavlo Golub

Nordic PGDay @nordicpgday.org · 18/03/2025

And now Pavlo will play a game with us! #postgresql #database #copenhagen

001