Kaarel's corner
  • Contact / Consulting
  • Search
✕
    • A "TPC-C"-like "extension-pack" for pgbench

      Posted on September 6, 2025

      Post thumbnail
      Post thumbnail
      TPC-C is supposedly the most objective performance measurement of OLTP database systems… and I’ve used it quite a fair bit over the years as well…yet, running it on Postgres is sadly not exactly as smooth as things typically are with Postgres 😔 If to compare at least with the wonderful... [Read More]
      Tags:
      • postgres
      • benchmarking
      • pgbench
      • performance
    • 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
    • Older Posts →
    • RSS
    • GitHub

    Kaarel Moppel  •  2025

    Powered by Beautiful Jekyll