Nothing here yet.
Nothing here yet.
Dec 26, 2020 · 7 min read · 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...
Join discussion
Oct 22, 2020 · 4 min read · 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...
Join discussion
Oct 10, 2020 · 1 min read · 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...
Join discussion
Oct 8, 2020 · 2 min read · 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...
Join discussion
Oct 5, 2020 · 3 min read · 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...
Join discussion