Kaarel's corner
  • Contact / Consulting
  • Search
✕
    • A TimescaleDB analytics trick

      Posted on August 19, 2024

      Post thumbnail
      Post thumbnail
      While everyone agrees that Postgres has a lot of really nice things going for it, the analytics story has lagged a bit as there are some hard problems to be solved - the on-disk format would have to be changed or IO-layer abstracted away even further to allow alternative engines,... [Read More]
      Tags:
      • postgres
      • timescaledb
      • analytics
      • performance
    • 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
    • ← Newer Posts
    • Older Posts →
    • RSS
    • GitHub

    Kaarel Moppel  •  2025

    Powered by Beautiful Jekyll