Kaarel's corner
  • Contact / Consulting
  • Search
✕
    • Best pg_basebackup compression settings for v15 and above

      Posted on March 27, 2024

      Post thumbnail
      Post thumbnail
      In my last post I did a quick check on the performance of the newer (lz4, zstd) pg_dump compression options, which included setting up a small framework to download some openly available “real life”-ish sample datasets. And the general result was that, indeed - the new algos in lower levels... [Read More]
      Tags:
      • postgres
      • pg_basebackup
      • backups
      • performance
    • Best pg_dump compression settings for Postgres in 2024

      Posted on January 5, 2024

      Post thumbnail
      Post thumbnail
      Time between Christmas and New Year is always a good quiet time to be able to concentrate and tick off some mouldy TODO list items. For me this time the top item was a script (which turned into a small framework somehow), to download and import some openly available “real... [Read More]
      Tags:
      • postgres
      • pgdump
      • backups
      • performance
    • TIL - When was my Postgres cluster initialized ?

      Posted on September 28, 2023

      Post thumbnail
      Post thumbnail
      Today again a nice finding after 12 years with Postgres - seems one can actually retrieve the time when a cluster / instance was once initialized! Given of course you haven’t dump-restored or in-place upgraded the instance in the mean time… [Read More]
      Tags:
      • postgres
      • initdb
      • rds
    • Postgres 16 - a quick perf check

      Posted on September 24, 2023

      “That time of the year”™ again 🎉 [Read More]
      Tags:
      • postgres
      • performance
      • pgbench
    • TIL - IN is not the same as ANY

      Posted on July 4, 2023

      Not exactly from today, rather from a month or two ago, but still on my “noteworthy list”. So after a remarkably long quiet period of no surprises (Postgres doesn’t generally surprise one badly), I managed to learn something controversial - a thing considered generally good, using ANY instead of IN-list... [Read More]
      Tags:
      • postgres
      • sql
    • ← Newer Posts
    • Older Posts →
    • RSS
    • GitHub

    Kaarel Moppel  •  2025

    Powered by Beautiful Jekyll