Blogs / Personal blogs

Pawel Urbanek

pawelurbanek.com

Backend developer with over 10 years of experience. Specializing in Ruby on Rails, Rust, PostgreSQL, and backend performance.

Popular posts
5
Total points
1,070
HN comments
507
Rank
#1,972 personal

Visit pawelurbanek.com → RSS feedOn Hacker News Mar 2018 – Jan 2022

Infrastructure & DevOps 2Web & Frontend 1Tools & Productivity 1Systems & Performance 1Startups 1Software Engineering 1

2

PostgreSQL query performance bottlenecks

PostgreSQL query planner is full of surprises, so a common-sense approach to writing performant queries is sometimes misleading. In this blog post, I'll describe examples of optimizing seemingly obvious queries with the help of EXPLAIN ANALYZE and Postgres metadata analysis.

4

How I spend less time on YouTube

Maybe I'm paranoid. But, I think there's a lot of smart people out there dedicating their life's work to make others keep watching videos. Since YouTube's incomprehensible decision to remove dislikes count it's become even easier to waste time on worthless content. In this blog post, I'll describe a simple trick that…