--- title: "A potpourri of Postgres 15 progressions." publication: "Postgres Weekly" issue: 469 published_at: "2022-08-31" canonical_url: "https://postgresweekly.com/issues/469" --- Plus Heroku's change of course, and PostGIS 3.3 released. | #​469 — August 31, 2022 [Web Version](https://postgresweekly.com/issues/469) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/zyauj12kmafhsls6apmh.jpg)](https://www.percona.com/blog/postgresql-15-stats-collector-gone-whats-new/) [Where Did the Stats Collector Go in Postgres 15?](https://www.percona.com/blog/postgresql-15-stats-collector-gone-whats-new/) — Postgres’ stats collector keeps tabs on how many times a table or index is scanned, when vacuums take place, etc. This information is usually stored in temporary files, but Postgres 15 has moved to a more direct memory-based approach – luckily, anything monitoring `pg_stat_*` views will continue to work as-is. Jobin Augustine [A 'public' Schema Change in Postgres 15](https://andreas.scherbaum.la/blog/archives/1120-Changes-to-the-public-schema-in-PostgreSQL-15-and-how-to-handle-upgrades.html) — Andreas explains how the _CREATE_ privilege will no longer be set by default for the _public_ schema and how this could rear its head during your eventual v14 to v15 upgrades. He concludes: _“It’s best not to rely on a writable_ public _schema at all.”_ [More discussion (from 2020) here.](https://www.postgresql.org/message-id/20201031163518.GB4039133@rfd.leadboat.com) Andreas Scherbaum [![\](https://copm.s3.amazonaws.com/c69c8b37.png)](https://playground.polyscale.ai/) [Move Your Postgres Data Closer to Users](https://playground.polyscale.ai/) — PolyScale automatically caches Postgres at the edge, making data-driven apps blazingly fast. Deploy it without writing code in a few minutes. See how fast it is with our [Playground demo](https://playground.polyscale.ai/). PolyScale.ai sponsor [Cloudflare Open Sources Its PgBouncer Fork](https://blog.cloudflare.com/open-sourcing-our-fork-of-pgbouncer/) — Cloudflare has been maintaining an internal fork of PgBouncer (the connection pooler) packed with authentication bug fixes and new features around per-user and connection pool isolation. [Now it’s public.](https://github.com/cloudflare/cf-pgbouncer) Justin Kwan (Cloudflare) **QUICK BITS:** - Last week, Heroku announced [a slight change of course](https://blog.heroku.com/next-chapter) and the discontinuation of their free plans (including on their popular Postgres service) from November 28, 2022. This provoked [an extensive discussion](https://news.ycombinator.com/item?id=32594533) on Hacker News. - 🐓 The [Postgres Pets](https://postgresql.pet/) are back – no cats or dogs this week, but [Holly the hen!](https://postgresql.pet/post/holly_the_hen/) If the humans of Postgres are more your thing, then they get interviewed too, over at [PostgreSQL Person of the Week](https://postgresql.life/) 😁 - Last week we mentioned the release of [PostgREST](https://postgrest.org/en/stable/) 10.0, a popular server that turns Postgres into the backend for a REST API, but now the [official release notes](https://postgrest.org/en/stable/releases/v10.0.0.html) are available. - Full time Postgres contributor Jacob Champion volunteered to be a 'PostgreSQL Commitfest Manager' in July – what's that? [He explains all here](https://www.timescale.com/blog/what-does-a-postgresql-commitfest-manager-do-and-should-you-become-one/) focusing on why _you_ might want to become a commitfest manager yourself one day. [`ALTER TABLE` ... `ADD COLUMN` Done Right](https://www.cybertec-postgresql.com/en/postgresql-alter-table-add-column-done-right/) — Adding a column to a table in production can certainly be a hair-raising experience.. Hans-Jürgen quickly looks at the implications. Hans-Jürgen Schönig ▶[How to Become a DBA](https://postgres.fm/episodes/how-to-become-a-dba) — What are the various tasks, expectations, and roles involved in both junior and senior database administration roles? Michael and Nikolay discuss. Postgres FM Podcast podcast [How Postgres 15 Improves Communication in Logical Replication](https://www.postgresql.fastware.com/blog/how-postgresql-15-improved-communication-in-logical-replication) — Technical enough that few of you will _need_ to know about this, but in short: communication between the WAL sender and receiver becomes more efficient and robust, and replication becomes slightly faster as a result. 👍 Wei Wang [Automate Schema Version Control and Migration on Aurora with Flyway and AWS Lambda](https://aws.amazon.com/blogs/database/automate-schema-version-control-and-migration-with-flyway-and-aws-lambda-on-amazon-aurora-postgresql/) — [Flyway](https://flywaydb.org/) is a Java-based version-driven schema management tool that supports (most) SQL databases and it can be set up along with some AWS Lambda serverless functions to deploy SQL scripts into Aurora Postgres environments on a regular basis. Gohil and Lonappan (AWS) 🛠 Code and Tools [PostGIS 3.3.0 Released: The Geospatial Extension](http://www.postgis.net/2022/08/27/postgis-3.3.0-released/) — PostGIS is ahead of the game by being best used with Postgres 15 ([which is still in beta](https://www.postgresql.org/about/news/postgresql-145-138-1212-1117-1022-and-15-beta-3-released-2496/)) but works with 11 and up. The [NEWS file](https://git.osgeo.org/gitea/postgis/postgis/src/tag/3.3.0/NEWS) covers the improvements, which are relatively minor. Regina Obe (PostGIS) [The Developer Experience You Always Wanted for Postgres](https://www.crunchybridge.com/start?utm_source=cppg-brief-0831) Crunchy Bridge sponsor [pgagroal 1.5.0: High Performance Protocol-Native Connection Pool](https://agroal.github.io/pgagroal//release/announcement/2022/08/30/pgagroal-1.5.0.html) — Adds log formatting and rotation support, plus more. There are also some new tutorials, including this [‘getting started’ guide.](https://github.com/agroal/pgagroal/blob/master/doc/GETTING_STARTED.md) Red Hat [pgAdmin 4 v6.13](https://www.postgresql.org/about/news/pgadmin-4-v613-released-2501/) [Diesel 2.0](https://github.com/diesel-rs/diesel) – Safe, extensible ORM and query builder for Rust. [pg-promise 10.12](https://github.com/vitaly-t/pg-promise) – Postgres interface for Node.js. [data-diff 0.2.5](https://github.com/datafold/data-diff) – Diff rows across two different databases. [timescaledb-tune 0.14](https://github.com/timescale/timescaledb-tune) – A tool for tuning TimescaleDB perf. [Cornucopia 0.8.2](https://github.com/cornucopia-rs/cornucopia) – Generate Rust interfaces from SQL queries. [Psycopg 3.1](https://github.com/psycopg/psycopg) – Next gen Postgres adapter for Python. [OxideDB 0.1.6](https://github.com/fcoury/oxide) – Teach Postgres to speak the MongoDB wire protocol. **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|*)