--- title: "Postgres 14 beta 2 released" publication: "Postgres Weekly" issue: 412 published_at: "2021-06-30" canonical_url: "https://postgresweekly.com/issues/412" --- Plus self-hosting vs managed databases, creating constraints over multiple rows, and some PostGIS goodies. | #​412 — June 30, 2021 [Web Version](https://postgresweekly.com/issues/412) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/cnwuagm5tkjflgdfo653.jpg)](https://www.pgmustard.com/blog/calculating-per-operation-times-in-postgres-explain-analyze) [Calculating Per-Operation Times in `EXPLAIN ANALYZE`](https://www.pgmustard.com/blog/calculating-per-operation-times-in-postgres-explain-analyze) — `EXPLAIN ANALYZE` is a great help for digging into query performance issues but breaking down the timings can be tricky. Here’s some pointers. Michael Christofides [PostgreSQL 14 Beta 2 Released](https://www.postgresql.org/about/news/postgresql-14-beta-2-released-2249/) — A month after beta 1 comes beta 2 packed with bug fixes for things people found in the first beta. As always, you can get the best idea of what’s in Postgres 14 via [the draft release notes](https://www.postgresql.org/docs/14/release-14.html). PostgreSQL Global Development Group [![\](https://copm.s3.amazonaws.com/1df0853e.png)](https://fauna.com/postgres?utm_source=PostgresWeekly&utm_medium=Newsletter&utm_campaign=CooperPress_Newsletters_2021) [An Operations-Free, Scalable & Flexible Postgres Alternative](https://fauna.com/postgres?utm_source=PostgresWeekly&utm_medium=Newsletter&utm_campaign=CooperPress_Newsletters_2021) — Fauna combines the operational integrity and relational modeling of Postgres with an interface and architecture that fits better with modern app development in the cloud. The goodness of Postgres without its operational bottlenecks - [Learn more about Fauna](https://fauna.com/postgres?utm_source=PostgresWeekly&utm_medium=Newsletter&utm_campaign=CooperPress_Newsletters_2021). Fauna sponsor [A Tale of Making a Company-Wide Standard `psqlrc`](https://www.depesz.com/2021/06/23/a-tale-of-making-company-wide-standard-psqlrc/) — When you’re in a company with lots of developers and Postgres servers, it can be helpful to extend `psql` to show more information in its prompt to help everyone know what they’re working on. Easier said than done! Hubert depesz Lubaczewski [Creating Constraints Over Multiple Rows](https://www.cybertec-postgresql.com/en/postgresql-constraints-over-multiple-rows/) — An aeronautically themed example of the nuances involved in different types of transaction isolation levels and working on multiple rows. Hans-Jürgen Schönig [Ask HN: Do You Self-Host Your Database?](https://news.ycombinator.com/item?id=27671376) — I’ve seen the self host vs managed database debate all over the place recently, so it was neat to see Hacker News take it on. Given the audience it’s perhaps unsurprising the majority expressed a preference for maintaining full control. Hacker News [Finding the Root Cause of Slow Postgres Queries Using EXPLAIN](https://pganalyze.com/ebooks/explain-slow-postgres-queries?utm_source=PostgresWeeklySecondary06302021) — An in-depth guide on how to use Postgres EXPLAIN to find and improve problematic query plans and how to use auto_explain. pganalyze sponsor [Setting up PostGIS on Ubuntu 20.04.2](https://www.cybertec-postgresql.com/en/postgis-setup-with-ubuntu-20-04-2/) — How to get PostGIS set up on Ubuntu 20.04, how to install PostGIS packages and how to install the PostGIS extension into Postgres. Florian Nadler [Using GeoDjango and PostGIS in Django](https://pganalyze.com/blog/geodjango-postgis) — How to get started with [GeoDjango](https://docs.djangoproject.com/en/3.2/ref/contrib/gis/) (a Django extension for building GIS webapps) and PostGIS to work with geospatial data in Postgres, gives a high level overview of different types of spatial data and then a bunch of examples. Adeyinka Adegbenro [PostgresqlCO.NF: Postgres Configuration for Humans](https://postgresqlco.nf/en/doc/param/) — An epic resource to dig into all the different settings Postgres provides, see what they’re about, and discover further resources. OnGres [pgmetrics 1.11.0: Collect and Display Stats from a Running Postgres Server](https://github.com/rapidloop/pgmetrics) — The [homepage](https://pgmetrics.io/) has a lot more info including [example output](https://pgmetrics.io/docs/index.html#example). RapidLoop [Deploying pgAdmin in Kubernetes](https://www.enterprisedb.com/blog/deploying-pgadmin-kubernetes) Dave Page **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! --- **Want more?** You might like [DB Weekly](https://dbweekly.com/?utm_source=pg&utm_medium=email&utm_campaign=footer-promo), our more general database newsletter covering data storage trends, new database types, and more. --- 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|*)