--- title: "April is the month for Postgres events" publication: "Postgres Weekly" issue: 491 published_at: "2023-02-01" canonical_url: "https://postgresweekly.com/issues/491" --- Plus a BPF-based lock tracer, a database documentation tool, and clipping the superuser's wings. | #​491 — February 1, 2023 [Web Version](https://postgresweekly.com/issues/491) Together with [![Percona logo\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_350,h_100/e_make_transparent/co_white,e_outline:7/egbfiqexzspzz9grnyef.png)](https://www.percona.com/ha-for-postgresql?utm_campaign=22q2-cm-campaign-pg-high-availability&utm_source=postgres-weekly&utm_medium=primary-newsletter&utm_content=ensure-fivenines) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/lepmfukbjm9bnypjasli.jpg)](https://www.cybertec-postgresql.com/en/transaction-id-wraparound-a-walk-on-the-wild-side/) [Transaction ID Wraparound: A Walk on the Wild Side](https://www.cybertec-postgresql.com/en/transaction-id-wraparound-a-walk-on-the-wild-side/) — "_For most people it is an abstract concept, a bogeyman lurking in the dark around the corner. Many people know horror stories about anti-wraparound autovacuum tanking performance or databases that stop working, but who has ever seen actual data loss? I decided to face the beast.._" Take a journey with Laurenz and you could too see data arise from "the dead." Laurenz Albe [Ask HN: How Do You Test SQL?](https://news.ycombinator.com/item?id=34602318) — Extensive discussion about the myriad of ways that people either do or don’t(!) test their SQL queries. _“Try and write any complex SQL as a series of semantically meaningful CTEs”_ resonated with folks. Hacker News [![\](https://copm.s3.amazonaws.com/b2d538a5.png)](https://www.percona.com/ha-for-postgresql?utm_campaign=22q2-cm-campaign-pg-high-availability&utm_source=postgres-weekly&utm_medium=primary-newsletter&utm_content=ensure-fivenines) [Does Your PostgreSQL Ensure a HA Level of 99.9%?](https://www.percona.com/ha-for-postgresql?utm_campaign=22q2-cm-campaign-pg-high-availability&utm_source=postgres-weekly&utm_medium=primary-newsletter&utm_content=ensure-fivenines) — Percona HA PostgreSQL architectures pull together open source tools and components to enhance and harden interoperability, ensuring your applications always have access to the data they need. Contact us to learn more about our architecture. Percona sponsor [Coming to v16: Surviving Without a Superuser](https://rhaas.blogspot.com/2023/01/surviving-without-superuser-coming-to.html) — A _superuser_ in Postgres gets the highest privileges possible and can access anything, including, to some extent, the operating system. If you want a superuser in _Postgres_ but not the OS, that’s tricky but becoming a lot easier in Postgres 16 thanks to [this update.](https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=cf5eb37c5ee0cc54c80d95c1695d7fca1f7c68cb) Robert goes into detail in this post. Robert Haas **SOME EVENTS NEWS:** - 📅 [PGDay/MED](https://2023.pgdaymed.org/) is a _Mediterranean_-oriented Postgres conference and will be taking place in Malta on April 13. They have a [call for speakers](https://www.postgresql.eu/events/pgdaymed2023/news/pgdaymed-2023-call-for-papers-76/) open till February 12. - 📅 Early bird registration has opened for [PgDay Chicago 2023](https://2023.pgdaychicago.org/) which takes place on April 20 in, surprisingly, Chicago 😁 - 📅 Last but not least in events news, [CitusCon's CFP closes this Sunday,](https://www.citusdata.com/cituscon/2023/cfp/) so if you want to speak, **now's the time to get that proposal submitted.** It's a virtual event taking place on April 18-19, so you don't even need to leave home. [Postgres's 'Supply Chain'](http://peter.eisentraut.org/blog/2023/01/30/postgresql-supply-chain) — Every significant project relies on many others. Peter notes that a few of Postgres’s dependencies are quite fragile, although it seems none of the problems are unique to Postgres. Peter Eisentraut [Stateful Postgres Storage Using Kubernetes](https://www.crunchydata.com/blog/stateful-postgres-storage-using-kubernetes) Ben Blattberg 🛠 Code and Tools [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/gjauwz1tjddw4adtpeh1.jpg)](https://github.com/k1LoW/tbls) [tbls: A CI-Friendly Tool for Documenting Databases](https://github.com/k1LoW/tbls) — Document a database automatically in Markdown format with schemas rendered via DOT, PlantUML, Mermaid, or direct to images. By default you get documentation covering columns, indexes, relations, and other schema details (here’s [a sample document](https://github.com/k1LoW/tbls/blob/main/sample/postgres/README.md)). Written in Go. Ken’ichiro Oyama [pg-lock-tracer: A BPF-Based Lock Tracer](https://github.com/jnidzwetzki/pg-lock-tracer) — An interesting way to dig into lock-related bottlenecks in Postgres when running on Linux. It observes the locking activity of a Postgres process by using eBPF instrumentation. Jan Nidzwetzki [The Postgres Host You’ve Been Looking For](https://crunchybridge.com/start?utm_source=cppg-lk-0125) Crunchy Bridge sponsor [Patroni 3.0: Template for Postgres High Availability](https://github.com/zalando/patroni) — A template to create your own customized, high-availability solution using Python and ZooKeeper, etcd, Consul or Kubernetes. [v3.0](https://github.com/zalando/patroni/blob/master/docs/releases.rst#version-300) notably adds [Citus support.](https://github.com/zalando/patroni/blob/master/docs/citus.rst) Zalando SE [pgslice: Postgres Partitioning 'As Easy As Pie'](https://github.com/ankane/pgslice) — A tool that can either generate or generate _and_ execute the required SQL statements to partition either new or existing tables with nothing to install server-side. Written in Ruby. Andrew Kane [pg-mem: An Experimental In-Memory Postgres Instance for Tests](https://github.com/oguimbal/pg-mem) — Aimed at Node.js and browser-based use cases due to being written in TypeScript. There’s [a playground](https://oguimbal.github.io/pg-mem-playground/) if you want to experiment with what it can handle. Olivier Guimbal - [pgx 0.7](https://github.com/tcdi/pgx/releases/tag/v0.7.0) ↳ Build Postgres extensions with Rust. - [Goose 3.9](https://github.com/pressly/goose) ↳ Database migrations with SQL changes or Go(lang) functions. - [Postgres Operator 1.9](https://github.com/zalando/postgres-operator) ↳ Manages PG clusters running in Kubernetes. - [Dexter 0.4.2](https://github.com/ankane/dexter) – Automatic indexer for Postgres. - [usql 0.13.8](https://github.com/xo/usql) - Universal CLI for databases. **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. Thanks! --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter.](https://postgresweekly.com/leave/*|UID|*)