Kaarel's corner
  • Contact / Consulting
  • Search
✕
    • Postgres User Group Tallinn next event on 27th of November

      Posted on November 23, 2024

      Post thumbnail
      Post thumbnail
      Meet Postgres User Group Tallinn / Estonia [Read More]
      Tags:
      • postgres
      • meetup
      • socializing
      • community
    • Postgres on Spot VMs - only for the crazy?

      Posted on November 19, 2024

      Post thumbnail
      Post thumbnail
      Postgres is already great, surely - even “too popular” one could complain with a twist…as this broadcast “was” actually supposed to be my Lightning Talk at last month’s pgConf.eu in Athens 🙂 But indeed, seems Postgres has in an awesome way gotten so big that it’s not like that anymore... [Read More]
      Tags:
      • postgres
      • spot
      • aws
      • self-managed
      • ansible
      • cost-saving
    • Cloning Postgres user privileges vs ChatGPT

      Posted on November 5, 2024

      Post thumbnail
      Post thumbnail
      At pgConf.eu in Athens - by the way, reported to be the largest PostgreSQL conference to date, attesting to the software’s undeniable success! - I got into a sort of interesting hallway discussion. I guess my chat companion was relatively new to the ecosystem - and said something along the... [Read More]
      Tags:
      • postgres
      • privileges
      • grants
      • documentation
      • cloning
      • beginner
    • 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
    • ← Newer Posts
    • Older Posts →
    • RSS
    • GitHub

    Kaarel Moppel  •  2025

    Powered by Beautiful Jekyll