Kaarel's corner
  • Contact / Consulting
  • Search
✕
    • 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
    • Can there be too many partitions?

      Posted on April 18, 2023

      Quite some time ago at work there was a need to partition a particularly huge table, because: a) bloat was getting out of hand - as, remember, so far only one Autovacuum worker can work on a single table or subpartition b) there might arise a need to extract /... [Read More]
      Tags:
      • postgres
      • performance
      • pgbench
    • ← Newer Posts
    • Older Posts →
    • RSS
    • GitHub

    Kaarel Moppel  •  2025

    Powered by Beautiful Jekyll