SDSebastian Dresslerinfatstacks.hashnode.dev·Dec 26, 2020 · 7 min readRust `struct` conversion to and from C `void*`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...00
SDSebastian Dresslerinfatstacks.hashnode.dev·Oct 22, 2020 · 4 min readExcel gone wild - fetch data from PostgreSQL via PythonI 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...00
SDSebastian Dresslerinfatstacks.hashnode.dev·Oct 10, 2020 · 1 min readBash patterns I use #3: run something in variations.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...00
SDSebastian Dresslerinfatstacks.hashnode.dev·Oct 8, 2020 · 2 min readBash patterns I use #2: argument parsing.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...00
SDSebastian Dresslerinfatstacks.hashnode.dev·Oct 5, 2020 · 3 min read(PL/pg)SQL patterns I useThis 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...00
