's Avatar

@lukas.fittl.com

72
Followers
84
Following
6
Posts
30.12.2024
Joined
Posts Following

Latest posts by @lukas.fittl.com

PGConf.dev 2026 schedule is live! We have a packed program this year. And we'll continue to add Community Discussion Sessions to Tuesday through April. https://2026.pgconf....

21.02.2026 20:17 👍 5 🔁 5 💬 0 📌 0
Preview
How Wikipedia Will Survive in the Age of AI (With Wikipedia’s CTO Selena Deckelmann) The Wikimedia Foundation’s chief technology and product officer explains how she helps manage one of the most visited sites in the world in the age of generative AI.

The Wikimedia Foundation’s chief technology and product officer explains how she helps manage one of the most visited sites in the world in the age of generative AI.

20.01.2026 18:15 👍 99 🔁 21 💬 4 📌 0
PG DATA 2026 - Powered by Eventzilla

🎉Early Bird Registration is NOW OPEN for PG DATA 2026!

Early Bird Tickets: Just $30 (first 100 registrations)
Student Early Bird Tickets: Only $20 (first 50 students)

🔗Register now: www.eventzilla.net/e/pg-data-20...

#PGDATA2026 #PostgreSQL #EarlyBird #TechConference

24.10.2025 17:49 👍 2 🔁 2 💬 0 📌 0
Post image

Tracking Plan Shapes with Lukas Fittl of pganalyze

#pgconfeu #postgresql #database #riga

24.10.2025 10:50 👍 2 🔁 1 💬 0 📌 0

Check out the interview with Platinum sponsor pganalyze just posted at https://2025.pgconf....!

#postgres #pgconfeu #riga #opensource #database

08.10.2025 10:05 👍 0 🔁 1 💬 0 📌 0
Stamp 18.0. - postgresql.git - This is the main PostgreSQL git repository.

Tom stamped PG 18. Just a few more days for the official release....

git.postgresql.org/cgit/postgre...

22.09.2025 20:29 👍 3 🔁 1 💬 1 📌 0
Preview
crates.io phishing campaign | Rust Blog Empowering everyone to build reliable and efficient software.

We received reports of a phishing campaign targeting crates​.io users. Do not click on links asking to authenticate to protect your account. More information: blog.rust-lang.org/2025/09/12/c...

12.09.2025 14:22 👍 112 🔁 57 💬 0 📌 2

Reminder: code review is not "to catch mistakes", it is a tool for understanding to limit bus/lottery factor first and foremost. When code is written (if you're lucky) by one human, having the second human abdicate their judgment to the machine is actively harmful to your team's code understanding.

28.07.2025 04:29 👍 252 🔁 89 💬 12 📌 3
Measuring SELECT ... FOR UPDATE Latency in PostgreSQL Are queries slow because they’re waiting to acquire locks, or because they’re taking a long time to find the actual rows?

New small blog post

"Measuring SELECT ... FOR UPDATE Latency in #PostgreSQL"

> Are queries slow because they’re waiting to acquire locks, or because they’re taking a long time to find the actual rows? :)

benoittgt.github.io/blog/postgre...

28.07.2025 16:24 👍 6 🔁 2 💬 2 📌 0
Preview
Malleable software: Restoring user agency in a world of locked-down apps The original promise of personal computing was a new kind of clay. Instead, we got appliances: built far away, sealed, unchangeable. In this essay, we envision malleable software: tools that users can...

New longform @inkandswitch.com essay! 📜

Malleable Software: Restoring user agency in a world of locked-down apps

by me, @joshuahhh.com, @pvh.ca and @seaofclouds.com

inkandswitch.com/essay/mallea...

It's about why people need agency over their software tools, and how to make that happen.

10.06.2025 14:52 👍 95 🔁 24 💬 3 📌 3
Preview
POSETTE: An Event for Postgres 2025 Happening Now! POSETTE: An Event for Postgres is a virtual and free developer event happening on June 10-12, 2025. Come watch the livestream to learn what you can do with the world’s most advanced…

👁️ Watch Lukas Fittl at #PosetteConf Livestream 1 as he explores best practices for tuning slow Postgres queries. ⁉️

posetteconf.com

lukas.fittl.com

#postgresql #databases #OpenSource #analytics

10.06.2025 18:03 👍 7 🔁 2 💬 0 📌 0

Thanks! Some more stabilizing still to be done, but I'm excited about the premise of getting this type of data more widely available. Plan IDs are also a potential building block to improve the plan management story for Postgres.

03.06.2025 20:12 👍 2 🔁 0 💬 1 📌 0
Preview
Postgres performance at any scale | PostgreSQL Tuning - pganalyze Deliver consistent database performance and availability through intelligent tuning advisors and continuous database profiling. Start with a free trial today.

We’re delighted to announce pganalyze as a Gold sponsor for PGConf NYC 2025!

pganalyze.com

@pganalyze #postgres #conference

02.06.2025 16:53 👍 2 🔁 2 💬 0 📌 0
Root Cause Analysis: PostgreSQL MultiXact member exhaustion incidents (May 2025) | Metronome blog Metronome experienced multiple API outages in May 2025 due to PostgreSQL MultiXact member space exhaustion during a planned database migration. This incident analysis explains the root cause, our resp...

Awesome post:

Root Cause Analysis: PostgreSQL MultiXact member exhaustion incidents (May 2025)

metronome.com/blog/root-ca...

21.05.2025 18:56 👍 2 🔁 2 💬 2 📌 0
Post image

Voting for unconference sessions here on Day 4 of #PGConfdev had some predictable winners (e.g. scaling PG development, multithreaded #PostgreSQL) & a few surprises too. And now the collaboration begins!

16.05.2025 14:40 👍 4 🔁 2 💬 0 📌 0
Post image

Live now at #PGConfdev in Montreal Lukas Fittl is on stage, diving into “Tracking plan shapes over time with Plan IDs & a new pg_stat_plans”—discover how core plan‑ID tracking, partition‑aware metrics, and an extensible pg_stat_plans can revolutionize your #PostgreSQL query analy

14.05.2025 20:49 👍 3 🔁 2 💬 0 📌 0

Thanks! And yes, I think that change will finally make effective_io_concurrency live up to its name and expectations :)

12.05.2025 01:13 👍 1 🔁 0 💬 0 📌 0

Nice explanation of the asynchronous I/O work that has been happening for Postgres: pganalyze.com/blog/postgre... Also interesting to see poor little effective_io_concurrency become a lot more useful! #postgres #postgresql #planetpg

12.05.2025 01:03 👍 1 🔁 1 💬 1 📌 0
Preview
PGConf NYC 2025 | PostgreSQL Conference PGConf NYC 2025 will be held from on September 29th - October 1st in New York City, NY at Convene 117 West 46th Street.

Our CFP is open through May 25th! But don’t delay, send us your talk proposal today!

2025.pgconf.nyc/callforpapers/

@PostgreSQL #postgres #conference

08.05.2025 12:17 👍 4 🔁 5 💬 0 📌 0
Preview
Schedule RailsConf 2025 is the world’s largest gathering of Rails developers, brought together to further discussion and learning about building, managing, and testing Rails applications. With a specific…

🚨 The RailsConf 2025 schedule is now LIVE!

This will be the FINAL RailsConf—a landmark event celebrating the past, present, and future of Rails.

See what's in store... 👀 railsconf.org/schedule/

10.04.2025 14:00 👍 10 🔁 7 💬 1 📌 1

Over the last few weeks I've been incrementally merging infrastructure for AIO into postgres. Just now I finally merged the first actual user of AIO ("streaming reads" now can use AIO).

It's been a long long road. I've been, with a lot of help along the way, working on this since some time in 2019.

30.03.2025 23:01 👍 4 🔁 2 💬 3 📌 0

Hooray for getting it committed! Here is to not finding any (more) odd untested parts of Postgres that want to get in the way ;)

31.03.2025 06:13 👍 1 🔁 0 💬 0 📌 0
Preview
Speaker: Lukas Fittl | POSETTE: An Event for Postgres 2025 Lukas Fittl, pganalyze, is a speaker for POSETTE: An Event for Postgres 2024. Lukas’s talk is titled “Best Practices for Tuning Slow Postgres Queries”.

🎶 "Best practices for tuning #PostgresQL queries" will be presented by Lukas Fittl @PosetteConf 2025 (Livestream 1 on Tue Jun 10th @ 11:00am PDT (UTC-7)). 🐘

Find out more: posetteconf.com/speakers/luk...

#postgres #databases #OpenSource #community

17.03.2025 15:30 👍 2 🔁 2 💬 1 📌 0
Preview
Selective asynchronous commits in PostgreSQL - balancing durability and performance Safely leverage PostgreSQL's asynchronous commit for significant performance gains

Wrote a bit about an interesting find lately www.shayon.dev/post/2025/75...

16.03.2025 16:48 👍 2 🔁 1 💬 0 📌 0

Besides the usability going down the more fields we add, I do wonder if there is performance overhead with the internal struct getting bigger and bigger? Probably not significant compared to the query text handling I suppose. It does seem useful to have this tracked though..

05.03.2025 21:52 👍 1 🔁 0 💬 1 📌 0
Preview
Postgres query plan visualization tools - pgMustard When you’ve got a slow Postgres query, EXPLAIN and its parameters are incredibly useful for working out why. However, the information returned can be difficult (and time-consuming) to interpret, espe...

Looks like that link 404s - I assume you meant to link to www.pgmustard.com/blog/postgre... - and agreed, finding the balance with posts that talk about one's own product is hard when you want to stay fair, but I think you did a good
job :)

05.03.2025 16:43 👍 3 🔁 0 💬 1 📌 0

Hey #rubyfriends, the deadline for RailsConf CFP is *today*, which means now it's the time to send that proposal you've been sitting on 💪🏻🙌🏻

28.02.2025 09:18 👍 12 🔁 8 💬 0 📌 0
Program

0900-1000: Compilers

    Database query compilation: our journey
    Viktor Leis & Thomas Neumann
    A YJIT interview
    Maxime Chevalier-Boisvert
    Can we democratize JIT compilers?
    Haoran Xu
    Safe and productive performance with user-schedulable languages
    Jonathan Ragan-Kelley

1000-1100: Understanding programs

    How debuggers work
    Sy Brand
    Debugging compiler-optimized code: how it works and doesn't
    Stephen Kell
    Side-Eye: ask your programs anything
    Andrei Matei
    Let’s run a million benchmarks
    Yao Yue
    Rocket science of simulation testing!
    Aleksey Kladov

1100-1200: Wild ideas

    Back to modularity
    Daniel Jackson
    DB usability: as if
    Jonathan Edwards
    Twizzler and far out memory sharing: precise abstractions
    Daniel Bittman
    Programming without pointers
    Andrew Kelley
    Throwing it all away - how extreme rewriting changed the way I build databases
    Tyler Neely

1200-1230: Programmers are people

    A case for feminism in programming language design
    Felienne Hermans
    Malloy, mic drop, peace!
    Michael Toy

1230-1300: Lightning talk buffet

1300-1400: Query languages

    ???
    Jeff Shute
    ???
    Tobias Brandt
    ???
    Yury Selivanov
    AquaLang: a dataflow programming language
    Klas Segeljakt
    A polymorphic data model for SQL using algebraic types
    Steve McCanne

1400-1430: Databases

    Use of time in distributed databases —don’t fall behind the times
    Murat Demirbas
    ???
    Thomas Ballinger
    Thank goodness we're not building a database
    Peter van Hardenburg

1430-1500: Wasm

    Thinking in wit
    Dan Gohman
    Bringing the WebAssembly standard up to speed with SpecTec
    Dongjun Youn

Program 0900-1000: Compilers Database query compilation: our journey Viktor Leis & Thomas Neumann A YJIT interview Maxime Chevalier-Boisvert Can we democratize JIT compilers? Haoran Xu Safe and productive performance with user-schedulable languages Jonathan Ragan-Kelley 1000-1100: Understanding programs How debuggers work Sy Brand Debugging compiler-optimized code: how it works and doesn't Stephen Kell Side-Eye: ask your programs anything Andrei Matei Let’s run a million benchmarks Yao Yue Rocket science of simulation testing! Aleksey Kladov 1100-1200: Wild ideas Back to modularity Daniel Jackson DB usability: as if Jonathan Edwards Twizzler and far out memory sharing: precise abstractions Daniel Bittman Programming without pointers Andrew Kelley Throwing it all away - how extreme rewriting changed the way I build databases Tyler Neely 1200-1230: Programmers are people A case for feminism in programming language design Felienne Hermans Malloy, mic drop, peace! Michael Toy 1230-1300: Lightning talk buffet 1300-1400: Query languages ??? Jeff Shute ??? Tobias Brandt ??? Yury Selivanov AquaLang: a dataflow programming language Klas Segeljakt A polymorphic data model for SQL using algebraic types Steve McCanne 1400-1430: Databases Use of time in distributed databases —don’t fall behind the times Murat Demirbas ??? Thomas Ballinger Thank goodness we're not building a database Peter van Hardenburg 1430-1500: Wasm Thinking in wit Dan Gohman Bringing the WebAssembly standard up to speed with SpecTec Dongjun Youn

The program is up and tickets are live at www.hytradboi.com/2025/#program.

I'll keep updating this thread as the last 10 talks hit camera-ready.

01.02.2025 02:46 👍 50 🔁 27 💬 1 📌 7
Preview
Avoid Postgres performance cliffs with MultiXact IDs and foreign keys We walk through problems you might encounter with MultiXact transaction IDs and give food for thought about when to us foreign keys in Postgres.

Yeah, I did a 5mins of Postgres episode about MultiXacts a while ago: pganalyze.com/blog/5mins-p... - the 17 changes will help sometimes at scale, but don't resolve all the challenges in my understanding. Best is to reduce/avoid requiring MultiXacts, if possible.

31.01.2025 23:47 👍 3 🔁 0 💬 0 📌 0