Kaarel's corner
  • Contact / Consulting
  • Search
✕
    • No, you don't necessarily need extensions to compact Postgres tables

      Posted on August 6, 2025

      Post thumbnail
      Post thumbnail
      Broadcasting a quick tip from a real-life “tasklet” where a customer was genuinely surprised why a seemingly logical fix didn’t show up on Google / LLM-s. So let’s see if we can improve on that situation. [Read More]
      Tags:
      • postgres
      • vacuum
      • bloat
      • pgbench
    • TIL - Debian comes with a pg_virtualenv wrapper!

      Posted on July 15, 2025

      Post thumbnail
      Post thumbnail
      Some weeks ago Postgres (well, not directly the official Postgres project) again managed to surprise me during my daily muscle-memory operations, prompting even one relatively lazy human to actually write about it. [Read More]
      Tags:
      • postgres
      • psql
      • testing
      • debian
      • ubuntu
    • Yes, Postgres can do session vars - but should you use them?

      Posted on June 3, 2025

      Post thumbnail
      Post thumbnail
      Animated by some comments / complaints about Postgres’ missing user variables story on a Reddit post about PostgreSQL pain points in the real world - I thought I’d elaborate a bit on sessions vars - which is indeed a little known Postgres functionality. [Read More]
      Tags:
      • postgres
      • features
      • tables
      • howto
    • Striping Postgres data volumes - a free lunch?

      Posted on April 24, 2025

      Post thumbnail
      Post thumbnail
      A small follow up on my previous post on various Postgres scale-up avenues in my preferred order. The post received quite a bit of interest - meaning people at least still “wish” performant databases :) And - the ones who are willing to put in a bit of effort with... [Read More]
      Tags:
      • postgres
      • performance
      • ebs
    • A roadmap to scaling Postgres

      Posted on April 10, 2025

      Post thumbnail
      Post thumbnail
      After meeting with another database fellow recently - the evergreen topic of database scaling popped up again. That won’t go out of fashion anytime soon I guess, despite the AI advancements and the rise of Postgres-aware chatbots a la Xata Agent. Namely - when to grab for which designs, technical... [Read More]
      Tags:
      • postgres
      • design
      • performance
    • Older Posts →
    • RSS
    • GitHub

    Kaarel Moppel  •  2025

    Powered by Beautiful Jekyll