Kaarel's corner
  • Contact / Consulting
  • Search
✕
    • 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
    • TIL - Starting in read-only mode the easy way

      Posted on March 27, 2025

      Post thumbnail
      Post thumbnail
      Once a year or so Postgres manages to surprise me for some of those daily DB micro-operations, that come from muscle memory usually, without any braincells spent. Today to my delight I stumbled on one such again - for the task of starting a psql session in a safe read-only... [Read More]
      Tags:
      • postgres
      • psql
      • libpq
    • Don't forget about the Postgres parallel leader participation setting

      Posted on January 22, 2025

      Post thumbnail
      Post thumbnail
      Recently there was a nice article on the Planet PostgreSQL feed on Postgres’ parallel query capabilities and the pertinent tuning parameters. All good and logical, the main settings and considerations were highlighted…but then I suddenly remembered that there’s one more parallelism relevant parameter that for some reason is mostly always... [Read More]
      Tags:
      • postgres
      • bigdata
      • parallelism
      • testing
      • pgbench
      • ansible
    • Postgres Synchronous Replication - a 99.99% guarantee only

      Posted on December 9, 2024

      Post thumbnail
      Post thumbnail
      At last week’s local Postgres user group meetup here in Estonia, one of the topics was HA and recent Patroni (the most popular cluster manager for Postgres) improvements in supporting quorum commit, which by the way on its own has been possible to use for years. Things went deep quickly... [Read More]
      Tags:
      • postgres
      • replication
      • ha
    • Older Posts →
    • RSS
    • GitHub

    Kaarel Moppel  •  2025

    Powered by Beautiful Jekyll