--- title: "The imminence of Postgres 15" publication: "Postgres Weekly" issue: 475 published_at: "2022-10-12" canonical_url: "https://postgresweekly.com/issues/475" --- Plus why partitioning makes even more sense in 2022, and how to approach writing your own Postgres driver. | ✏️ Last week we noted that Postgres 15 was likely to drop on October 13 and that this issue might be delayed. However, there's speculation it _might_ be delayed to October 20. Given this, we're sending this issue today and if Postgres 15 _does_ get released tomorrow, we'll send a quick, extra 'newsflash' email to let you know. __ _Peter Cooper, your editor_ #​475 — October 12, 2022 [Web Version](https://postgresweekly.com/issues/475) Together with [![Crunchydata\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,w_430,h_100/e_make_transparent/co_white,e_outline:7/xyflkz7n00elwtgja9ne.png)](https://www.crunchydata.com/case-studies/niftys?utm_source=cppg-prim-1013) Postgres Weekly [Partitioning in Postgres – 2022 Edition](https://brandur.org/fragments/postgres-partitioning-2022) — A reflection on the shifting benefits and drawbacks of using partitioned tables in Postgres while noting that things are better now than ever before: _“Progress on this feature over 5 years is downright incredible. Managing a partitioned table is 90% as easy as a normal one.”_ Brandur Leach [Postgres 15 is.. _Almost_ Here!](https://www.enterprisedb.com/blog/postgres-15-coming) — [RC 2 dropped](https://www.postgresql.org/about/news/postgresql-15-rc-2-released-2521/) last week, and the final is due either tomorrow or on October 20 🤞 Lætitia reminds us of the roadmap here, but if you’d rather hear about some features, [here are a few to get excited about.](https://www.percona.com/blog/postgresql-15-new-features-to-be-excited-about/) Lætitia Avrot [![\](https://copm.s3.amazonaws.com/3a8155dc.png)](https://www.crunchydata.com/case-studies/niftys?utm_source=cppg-prim-1013) [Niftys Migrates to Crunchy Bridge from Serverless](https://www.crunchydata.com/case-studies/niftys?utm_source=cppg-prim-1013) — Find out why vanilla Postgres is a more cost effective and simple way to manage your database than shiny “Postgres” compatible services. Read a customer case study on getting a better database experience with better support on Crunchy Bridge. Crunchy Bridge sponsor [Six Findings to Rely On When Managing Postgres Indexes](https://knock.app/blog/postgres-index-findings) — _Knock_ is a notifications platform that uses Postgres as its primary data store and they’ve shared some lessons learnt from tuning their indexes. Ultimately, it comes down to making tradeoffs between query flexibility and efficiency. Billy Ceskavich [The Why and How of Connection Pooling with `pgbouncer`](https://www.cybertec-postgresql.com/en/pgbouncer-types-of-postgresql-connection-pooling/) — _“Connections are not free,”_ so you might use some sort of proxy or pooler like [pgbouncer](https://www.pgbouncer.org/) to manage the connection load upon your database. This post explains the basics. Hans-Jürgen Schönig **IN BRIEF:** - The first _PGSQL Phriday_ Postgres community blogging event [wrapped up nicely](https://www.softwareandbooz.com/pgsql-phriday-001-wrap-up-and-review/) with [1](https://mydbanotebook.org/post/2-it-depends-and-1-must/), [2](https://www.lhorn.de//pgsql-phriday-001---two-truths-and-a-lie-about-postgresql11979.html), [3](https://www.scarydba.com/2022/10/07/pgsql-phriday-001-two-truths-and-a-lie/), [4](https://andreas.scherbaum.la/blog/archives/1121-PGSQL-Phriday-001-Two-truths-and-a-lie.html), [5](https://andyatkinson.com/blog/2022/10/07/pgsqlphriday-2-truths-lie).. [6!](https://sqlasylum.wordpress.com/2022/10/07/pgsqlphriday-001-truth-and-lies/) posts each sharing three best practices, but one of which is a (disclosed) lie! See if you can spot the sneakiness of the authors.. - The _PostgreSQL Community Code of Conduct Committee_ (try saying that ten times quickly) has welcomed [three new members](https://www.postgresql.org/about/news/new-members-of-the-community-code-of-conduct-committee-2525/). - Crunchy Data's Paul Laurence reflects on [five years of Postgres on Kubernetes](https://thenewstack.io/5-years-of-postgres-on-kubernetes/). [Writing Your Own Postgres Driver (in Go)](https://medium.com/scum-gazeta/writing-your-own-postgresql-driver-ebd5fd6d187d) — An increasing number of non-Postgres systems are now using Postgres’s wire protocol for interoperability reasons, so why not join the fun and write your own Postgres _client_? This post digs into the protocol a little and provides guidance, without taking away all the fun. Konstantin Makarov [How are MySQL and Postgres ENUMs Different?](https://readyset.io/blog/enums-mysql-vs-postgres) — Nick gets in early with the Halloween stories with a look at the ‘spooky internals’ of how ENUMs are handled in MySQL versus Postgres. Nick Marino [Learn About Postgres 15 and More in Our 5mins of Postgres Video Series](https://pganalyze.com/blog?utm_source=PostgresWeeklySecondary10132022) pganalyze sponsor [Migrate Oracle’s XMLDOM Package Functions to Amazon Aurora PostgreSQL Using JSON](https://aws.amazon.com/blogs/database/migrate-oracles-xmldom-package-functions-to-amazon-aurora-postgresql-using-json-format/) — AWS is still very keen for you to migrate away from Oracle. Kumar and Parthasaradhi (AWS) [Don’t Forget to Tune the Stats Collector on PG 14 and Older](https://www.percona.com/blog/dont-forget-to-tune-stats-collector-for-postgresql-14-and-older/) Jobin Augustine 🛠 Code and Tools [pg_auto_failover 2.0: Extension That Manages Failover for Postgres Clusters](https://pg-auto-failover.readthedocs.io/en/v2.0/index.html) — Say hello to Postgres 15 and Citus support. Microsoft [SI Units for Postgres](https://github.com/df7cb/postgresql-unit) — Over 2400 units imported from GNU Units including meters, kilograms, seconds, amperes, radians, lumens, and more. Learnt about this in the author’s [Postgres Person of the Week interview](https://postgresql.life/post/christoph_berg/) where he reveals how his background as a trained physicist led to this extension. Christoph Berg ['Don’t Make Databases Available on the Public Internet'](https://tailscale.com/blog/introducing-pgproxy/) — A response to a popular article last week about [how many Postgres servers aren’t using SSL.](https://innerjoin.bit.io/the-majority-of-postgresql-servers-on-the-internet-are-insecure-f1e5ea4b3da3) Their solution is quite specific to Tailscale (a true VPN system for your own devices) but they’ve written has written and open sourced a _TLS-enforcing Postgres proxy_ called [pgproxy](https://github.com/tailscale/tailscale/tree/main/cmd/pgproxy) to bridge between Tailscale and external Postgres servers. Tailscale - [pgx 0.5](https://github.com/tcdi/pgx) ↳ Build Postgres extensions with Rust. - [PgHero 3.0.1](https://github.com/ankane/pghero) ↳ A performance dashboard for Postgres - [pgcat 0.3](https://github.com/levkk/pgcat) ↳ Postgres pooler with sharding, load balancing and failover support. - [ruby-pg 1.4.4](https://github.com/ged/ruby-pg) ↳ PostgreSQL client library for Ruby. - [Hypershield 0.3](https://github.com/ankane/hypershield) ↳ Shield sensitive data in Postgres and MySQL ❓ Did You Know.. Luca Ferrari shows off [Postgres's ASCII numeric operators](https://fluca1978.github.io/2022/10/10/PostgreSQLNumericOperators.html) and while using `+` or `-` for addition and subtraction are universally known, did you know `|/` can be used to calculate a square root or that `@` can act the same as `abs`? Thankfully, most of Postgres's [math functions](https://www.postgresql.org/docs/14/functions-math.html) stick to more boring names however :-) **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|*)