Kaarel's corner
  • About
  • Search
✕
    • 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
    • Postgres v15 - a billion transactions later

      Posted on November 9, 2022

      As the last Postgres release, carrying the number 15, seemed kind of an “anniversary” release to me, I thought it would be fun / useful to run a series of tests to try to gauge the scale of improvements over the last 5 years, i.e. putting v10 and v15 in... [Read More]
      Tags:
      • postgres
      • performance
      • pgbench
    • 5 years in PostgreSQL major versions performance - anything surprising?

      Posted on September 5, 2022

      First off - :wave: heya old friends, it’s been a while! After a slight “busy-with-other-things” hiatus (changing jobs, genome multiplication) I thought it’s about time to hit the keyboard again to avoid becoming overly “rusty” with writing and also to help my ageing brain in future as it’s pretty neat... [Read More]
      Tags:
      • postgres
      • performance
      • beta
    • RSS
    • GitHub

    Kaarel Moppel  •  2022

    Powered by Beautiful Jekyll