Profile avatar
tanelpoder.com
Creator of https://0x.tools, also a long-time computer performance geek. Perf & troubleshooting blog: tanelpoder.com. All onions are mine.
236 posts 1,309 followers 471 following
Prolific Poster
Conversation Starter

Workaccount2 on Hacker News just coined the term "context rot" to describe the thing where the quality of an LLM conversation drops as the context fills up with accumulated distractions and dead ends news.ycombinator.com/item?id=4430...

yesssss

My blog has turned 18 years old! tanelpoder.com/posts/my-blo...

If you use "AI agents" (LLMs calling tools in a loop) you need to be aware of the Lethal Trifecta Combine access to private data, exposure to untrusted content and the ability to externally communicate and an attacker can trick the system into stealing your data simonwillison.net/2025/Jun/16/...

GitHub Issues search now supports nested queries and boolean operators: Here’s how we (re)built it Sounds like a simple thing to add, eh? WIth a sufficiently big system, things become complex anyway and having an own custom query parser is always fun.

"Profile coverage of functional tests without instrumenting your binaries" with eBPF 🐝 From Massimiliano Giovagnoli

how to read a C++ codebase: 1. compile it with DWARF debug info enabled 2. open it in Ghidra 3. look at the C decompilation

New benchmark just dropped: SnitchBench by Theo Browne tests if LLMs will snitch on you to the authorities if you feed them incriminating documents and a tool that lets them send email, as seen in the Claude 4 System Card Turns out they pretty much all will! simonwillison.net/2025/May/31/...

New Blog: Catbench Vector Search Playground has Postgres Query Throughput and Latency Monitoring Now This is a demo app that helps you to learn and experiment with adding vector search-based functionality into new or existing apps! (link in reply)

The curse of social media: not just for software engineering but other areas as I observe (say, hiring, investing, product management, venture capital etc) Those the best at their craft are usually busy building not writing/posting. Viral posts often wrong in many ways etc Via @icooper.bsky.social

Previously on the blog. UNLONG my dictionary those pesky LONG columns. https://connor-mcdonald.com/2021/04/06/unlong-my-dictionary-those-pesky-long-columns/

New blog: Using Postgres pg_test_fsync tool for testing low latency writes An easy to use tool that comes with standard Postgres installation, for testing write latency of devices where you put your WAL/redo logs and any other files requiring low write latency. (link in reply)

New blog: Using Postgres pg_test_fsync tool for testing low latency writes An easy to use tool that comes with standard Postgres installation, for testing write latency of devices where you put your WAL/redo logs and any other files requiring low write latency. (link in reply)

BONUS SESSION AT #POUG2025 with @tanelpoder.com !! 💡 Topic: Using eBPF to achieve ASH for everything on Linux ⚙️ Live demo of tools like xtop 🧠 2–3 hours of deep, geek-level insights 📅 Early October | 🎥 Recorded ..book your ticket it before it's too late: poug2025.konfeo.com

FlameGraphs of #SQL execution plans are a good way to see which are the slowest parts => where you should focus your tuning efforts @tanelpoder.com has tweaked his script to generate these to include Number of starts Row counts

Postgres IDE in VS Code announced by Microsoft: techcommunity.microsoft.com/blog/adforpo...

Blog: Python Supports Profiling with Perf - How Does It Work? (2024) Link in reply

🎬This Friday, @lizrice.com will explore eBPF-based packet filtering with bpfilter eBPF & Cilium Office Hours Friday, 23rd May, 2025 - 7 pm UK time Livestream: youtube.com/live/aNzFneO...

Ever thought of joining DeepMind's RL team? We're recruiting for a research engineering role in London: job-boards.greenhouse.io/deepmind/job... Please spread the word!

Today is the last day for getting access to my unique (and awesome) training courses at significant discounts!!! Link in reply!

Today is the last day for getting access to my unique (and awesome) training courses at significant discounts!!! Link in reply!

Last week I had the privilege to give a keynote at the International Conference on Performance Evaluation (ICPE'25). It wasn't recorded, so I captured the key points as a blog post: brooker.co.za/blog/2025/05...

🔬 We've been researching PGO with sampling profiling data for Rust (and LLVM more generally) at Polar Signals. Check out what Tommy has found so far and stay tuned for the next posts in this series! 🧊 www.polarsignals.com/blog/posts/2...

Back in my young days (of January 2025), I used to pay for multiple AI models from different vendors - to use the best tool for a given task. Now it's only Gemini for me. 2.5 Pro for harder things and 2.5 Flash for quick responses. Lower cognitive overhead of what to use, too.

DuckDB 1.3.0 is out: - External File Cache (like caching remote S3 file chunks locally) - UUID v7 support - Spatial Join operator - Rewritten Parquet support duckdb.org/2025/05/21/a...

The comment period for this ends in 3 DAYS. Please leave a comment telling them EVERYONE should be able to get covid boosters. www.regulations.gov/commenton/FD...

1/11 A thread on Oracle redo copy latch internals. Part 1 - FG latch acquisition

Getting the OS timezone from the database. Can you think of a better way? connor-mcdonald.com/2025/05/21/d...

HUGE news 5 years, Epic spending ~$100M on lawyer fees... and the court ruled that Apple cannot block Fortnite just because it uses web payments where Apple cannot take a 30% cut! (I's not Apple's infra, and Apple has nothing to do with it!) Now other apps will follow. Massive

Functions on columns in the WHERE clause of #SQL queries => poor estimates => poor plans If you must use the functions, @danischnider.bsky.social has these tips to improve estimates in Oracle Dat Function-based index Virtual column Extended statistics

I'm speaking at this year's #P99CONF as well! Launching the latest version of my 0x.tools xcapture tool as promised, using modern eBPF & all the benefits it provides! "xCapture v3: Efficient, Always-On Thread Level Observability with eBPF" www.p99conf.io

I'm speaking at this year's #P99CONF as well! Launching the latest version of my 0x.tools xcapture tool as promised, using modern eBPF & all the benefits it provides! "xCapture v3: Efficient, Always-On Thread Level Observability with eBPF" www.p99conf.io

I extended @ramikrispin.bsky.social's excellent work to use Claude Sonnet 3.7 to translate natural language data queries into runnable SQL. Along the way, I showed that Claude can do this even with English questions against a non-English dataset. www.crosstab.io/articles/llm...

This is really cool: Getting AI to write good SQL: Text-to-SQL techniques explained cloud.google.com/blog/product...

Still useful: Scripts for Drilling Down Into Unknown Optimizer Changes (2018) This is about my optimizer_feature_matrix.sql, cofep.sql, cofef.sql scripts for comparing optimizer parameter and fix control flips across optimizer_features_enabled settings. tanelpoder.com/posts/script...