Kaarel's corner
  • Contact / Consulting
  • Search
✕
    • 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
    • Generating lots of test data with Postgres, fast and faster

      Posted on December 23, 2022

      After having worked many years with databases, some things become kind of second nature, so that you don’t think about it really - if there’s a need, you just type in some commands on the console and move on with other things. One of such things is for example generating... [Read More]
      Tags:
      • postgres
      • testing
      • testdata
      • pgbench
      • generate_series
    • The bountiful world of Postgres indexing options

      Posted on December 9, 2022

      Last week’s Postgres Weekly had quite an interesting piece that compared the performance of composite indexes vs normal indexes being merged on-the-fly. And especially interesting - throwing MySQL also into the ring! Recently “sadly” not too much on that comparison front somehow - ah, those good old flame war days…... [Read More]
      Tags:
      • postgres
      • indexing
      • btree
      • hash
      • pgbench
    • ← Newer Posts
    • Older Posts →
    • RSS
    • GitHub

    Kaarel Moppel  •  2025

    Powered by Beautiful Jekyll