--- title: "How to get started with building and debugging Postgres" publication: "Postgres Weekly" issue: 619 published_at: "2025-10-09" canonical_url: "https://postgresweekly.com/issues/619" --- Plus the CFP for pgDay Paris, more diving into Postgres 18, and pgwatch v4.0. | #​619 — October 9, 2025 [Web Version](https://postgresweekly.com/issues/619) Together with [![Bytebase\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_1280,h_275/e_make_transparent/co_white,e_outline:15/e5dl5r6iycqdzkcttmcu.png)](https://www.bytebase.com/?utm_source=postgres_weekly&utm_medium=email&utm_campaign=postgres_weekly_20251009) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/myxf1as8sucatryemg4h.jpg)](https://sbaziotis.com/databases/building-and-debugging-postgres.html) [Building and Debugging Postgres](https://sbaziotis.com/databases/building-and-debugging-postgres.html) — How to set up a container for building Postgres from source and then debugging it from GDB and VS Code. Useful tips if you want to start digging around Postgres internals. Stefanos Baziotis [Exploring Postgres to Parquet Archival for JSON Data with S3 Range Reads](https://www.shayon.dev/post/2025/276/exploring-postgresql-to-parquet-archival-for-json-data-with-s3-range-reads/) — How to move ‘cold’ JSON from Postgres to Parquet on S3 and then be able to fetch it back fast without reading whole files. Shayon Mukherjee [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/717829e4.png)](https://www.bytebase.com/?utm_source=postgres_weekly&utm_medium=email&utm_campaign=postgres_weekly_20251009) [How to Implement Postgres DevOps and Security](https://www.bytebase.com/?utm_source=postgres_weekly&utm_medium=email&utm_campaign=postgres_weekly_20251009) — Review, approve, deploy, and enforce query access control. Plus dynamic data masking and audit trails. All-in-one GUI workspace, open-source, trusted by 350+ companies, including Linear and note​.com. Bytebase sponsor ▶[Hands on Postgres 18: Async I/O, B-Tree Skip Scan, UUIDv7](https://www.youtube.com/watch?v=RTXeA5svapg) — The founder of [pganalyze](https://pganalyze.com/) presented a webinar digging into some of more noteworthy improvements in Postgres 18. The section on asynchronous I/O (running from 4:20 to 22:30) is particularly useful. Lukas Fittl **IN BRIEF:** - 🌐 [PostGIS Day 2025](https://www.snowflake.com/postgis-day-2025/) is a free, online event taking place on November 20 for Postgres users interested in geospatial applications. - 🇫🇷 [The call for papers for pgDay Paris 2026](https://2026.pgday.paris/call-for-papers/) is now open. It takes place in March 2026, with the submission deadline being December 19. - Long-standing Postgres consultancy company [CYBERTEC](https://www.cybertec-postgresql.com/en/) is celebrating its 25th anniversary with [an interview with CEO and founder Hans-Jürgen Schönig](https://www.cybertec-postgresql.com/en/how-it-all-began-25-years-of-cybertec/) covering how the company was formed and grown. - 🇯🇵 [PostgreSQL Conference Japan 2025](https://www.postgresql.jp/jpug-pgcon2025) takes place this November 11 in Tokyo. [On Developing OAuth Support for Postgres](https://www.enterprisedb.com/blog/developing-oauth) — One of the first champions for OAuth support in Postgres ([explored in a practical sense here](https://www.enterprisedb.com/blog/preview-postgresql-18s-oauth2-authentication-1-explore-how-it-works)) tells the tale of how it came to be in Postgres 18, why it’s exciting, and what’s yet to come. Jacob Champion 📄 [Ratcheting with Postgres `CONSTRAINT`](https://andrewjudson.com/ratcheting-with-postgres-constraint) – A way to enforce constraints (e.g. ‘NOT NULL’) for _future_ queries without having to immediately enforce them table-wide. Andrew Judson 📄 [Postgres Migrations Using Logical Replication](https://www.crunchydata.com/blog/postgres-migrations-using-logical-replication) Elizabeth Christensen 📄 [IBM Invites CockroachDB to Infest Its Mainframes with 'PostgreSQL'](https://www.theregister.com/2025/10/08/ibm_cockroachdb_mainframe_postgres/) – A typically quirky headline for _The Register_! The real story is IBM is looking to offer a Postgres_-like_ database on its mainframe hardware. The Register 📄 [SkipScan in TimescaleDB: Why `DISTINCT` Was Slow, How We Built It, and How You Can Use It](https://www.tigerdata.com/blog/skipscan-in-timescaledb-why-distinct-was-slow-how-we-built-it-and-how-you-can-use-it) Aksman and Hein (TigerData) 📄 [Key Operational Enhancements and Integration Options in Postgres 16](https://severalnines.com/blog/key-operational-enhancements-and-integration-options-in-postgresql-16/) Sebastian Insausti **RELEASES:** [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/ilr1y1fd1qnoc2gwjagy.jpg)](https://pgwat.ch/latest/) [pgwatch 4.0: A Flexible Postgres Monitoring Solution](https://pgwat.ch/latest/) — Provides a user-friendly interface through Grafana dashboards, letting you inspect various metrics (health, performance, index usage, I/O, etc.) and trends. [v4.0](https://github.com/cybertec-postgresql/pgwatch/releases/tag/v4.0.0) introduces a variety of enhancements and drops Grafana v10 support. CYBERTEC [pg_statement_rollback v1.5: Server Side Rollback at Statement Level](https://github.com/HexaCluster/pg_statement_rollback) — Add server side transaction rollback at statement level, like in Oracle or Db2. This version adds Postgres 18 support. Hexacluster - [PostgreSQL R2DBC Driver 1.1](https://github.com/pgjdbc/r2dbc-postgresql/releases/tag/v1.1.0.RELEASE) – Bringing reactive APIs to relational databases in the Java world. - [QuestDB 9.1](https://github.com/questdb/questdb/releases/tag/9.1.0) – Java-powered time-series database with Postgres wire protocol compatibility. - [River 0.26](https://github.com/riverqueue/river) – Fast & reliable Postgres-powered background jobs system for Go. - [tbls 1.89](https://github.com/k1LoW/tbls) – Auto document a database in Markdown format, such as in CI. - [Goose 3.26](https://github.com/pressly/goose) – Database migration tool. Supports SQL _and_ Go functions. - [Mathesar 0.6](https://github.com/mathesar-foundation/mathesar) – A spreadsheet-like interface for Postgres tables. - [Barman 3.16](https://github.com/EnterpriseDB/barman/releases/tag/release%2F3.16.0) – Backup and disaster recovery tool. **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|*).