Kaarel's corner
  • Contact / Consulting
  • Search
✕
    • 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
    • TIL - Filling prepared statement placeholders automatically with pgbadger

      Posted on June 7, 2023

      Hey Postgres friends! Thought I’ll try out a new shorter broadcasting format as seems finding some hours for proper blog posts is getting increasingly harder and harder. So here a first “Today I learned” type of post on a very useful feature of pgbadger that I just discovered for myself... [Read More]
      Tags:
      • postgres
      • pgbadger
      • logfiles
    • ← Newer Posts
    • Older Posts →
    • RSS
    • GitHub

    Kaarel Moppel  •  2025

    Powered by Beautiful Jekyll