Mark Wong's Blog

I used AI tools to size an OLTP workload on an EC2 system, with DBT-5, a TPC-E-like fair-use implementation.

The PostgreSQL Performance Farm is still not quite a reality, but I think there is some hope on the horizon.

I shared a chart, in 2022, showing where PostgreSQL contributor gifts are mailed to.

It feels like it was time to revisit the PostgreSQL Performance Farm that Tomas Vondra envisioned back in 2010.

This is a short story about how quickly charts can be created between the handful of plotting engines that I've experimented with.

Over the years, I’ve collected somewhere between 2 to 3 dozen buildfarm animals for supporting PostgreSQL’s development.

PostgreSQL v15 was released just last October and a group of volunteers have been sending out gifts for the contributors acknowledged in the released notes.

At PGCon 2020, I gave a presentation proposing that the PostgreSQL community could use better benchmarking tools to serve the open source developers.

On a whim I wanted to try making HTTP calls to access postgres so I slapped something together and called it pg_httpd.

IBM has been kind enough to loan us a pair of Power 730 Express servers.

markwkm=# select procpid, datname, comm, current_query, starttime, rss from pg_stat_activity, pg_proctab() where procpid = pid; procpid | datname | comm | current_query | starttime | rss ---------+---------+----------+-------------------------------------…

April 26 & April 27 in Bellingham, WA.

Here's a brief C example that takes an array of VARCHAR as input, iterates through the items and prints them out using elog().