I am currently Solutions Architect at Swarm64. I like to play with PostgreSQL and applications around it. The more data, the better.
I thought it would be a good idea to write a PostgreSQL foreign data wrapper (FDW) in Rust with PGX. My top three reasons: Learn how to write an FDW Get deeper into Rust programming Have some fun Turns out things are taking much longer than I assum...
I am benchmarking quite a lot these days. My latest toy is a homemade HTAP workload based on TPC-C and TPC-H. Written in Python and PL/pgSQL. The output looks like this: There are also statistics in a secondary PostgreSQL database. Being a sometimes...
This is part three of the "Bash patterns" series. The second part covers argument parsing. True story: my CMO asks me to run this benchmark. But, this time it is not a one-off. Instead, we need permutations on compression methods and levels. I typica...
This is the 2nd part of the "Bash patterns I use" series. The first pattern covered Limiting parallelism in Bash. In this part I'll show what I typically use when to parse arguments. This is inspired by this very excellent StackOverflow answer to th...
This is supposed to be the addition to the other patterns post "Bash patterns I use" but for SQL and/or PL/pgSQL. Create partitions with a function (hacky variant) This comes in handy when you need a bunch of partitions on a PostgreSQL table. Sure, t...
This post will be a collection of some patterns I typically use when working with Bash. There's not much in here yet, as I just now got the idea to share them ;-) Execute in parallel but with worker limit Suppose you have to load a bunch of CSV files...
