--- title: "Postgres 14 beta 1 released" publication: "Postgres Weekly" issue: 407 published_at: "2021-05-26" canonical_url: "https://postgresweekly.com/issues/407" --- Plus how to simulate a LIMIT on UPDATE or DELETE statements. | #​407 — May 26, 2021 [Web Version](https://postgresweekly.com/issues/407) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/rhy2ssunlcyqusgegazw.jpg)](https://www.postgresql.org/about/news/postgresql-14-beta-1-released-2213/) [PostgreSQL 14 Beta 1 Released](https://www.postgresql.org/about/news/postgresql-14-beta-1-released-2213/) — The first “this is ready for you to give it a try” release of the next major release is here. What do we get? - performance improvements across the board - [new multirange types](https://www.postgresql.org/docs/14/rangetypes.html#RANGETYPES-BUILTIN) - `VACUUM` enhancements - [JSON subscripting](https://erthalion.info/2021/03/03/subscripting/) - and [much more](https://www.postgresql.org/docs/14/release-14.html), naturally. PostgreSQL Global Development Group [An Early Look at Postgres 14: Performance and Monitoring Improvements](https://pganalyze.com/blog/postgres-14-performance-monitoring) — The official news (above) is one thing, but it’s always nice to see someone in the community chewing over a release and the implications in areas beyond just the feature set. Lukas Fittl [![\](https://copm.s3.amazonaws.com/83e2620f.png)](https://pganalyze.com/ebooks/explain-slow-postgres-queries?utm_source=RubyWeeklySecondary05262021) [Finding the Root Cause of Slow Postgres Queries Using EXPLAIN](https://pganalyze.com/ebooks/explain-slow-postgres-queries?utm_source=RubyWeeklySecondary05262021) — In this in-depth guide, you will learn how to use Postgres EXPLAIN to find and improve problematic query plans, how you can improve these query plans, and how to use auto_explain to automatically start collecting EXPLAIN plans. pganalyze sponsor [Simulating `UPDATE` or `DELETE` with `LIMIT`: CTEs to The Rescue](https://blog.crunchydata.com/blog/simulating-update-or-delete-with-limit-in-postgres-ctes-to-the-rescue) — Ever yearned for an UPDATE or DELETE statement with a LIMIT feature? Well, it’s not _quite_ that simple out-of-the-box, and even the SQL standard has no say in the matter, but David brings a worthwhile approach together here. An enjoyable post! David Christensen [On Bulk Loading Huge Amounts of Data](https://www.cybertec-postgresql.com/en/postgresql-bulk-loading-huge-amounts-of-data/) — This is one of those perennial topics and if you’ve tried loading huge amounts of data into a Postgres data _en masse_, you’ll know why.. there are numerous approaches, pros and cons for each, and it’s easy to end up with a job that takes ages. Hans-Jürgen shares some useful pointers. Hans-Jürgen Schönig [This Week's Postgres-Related Microsoft _Build_ Announcements](https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/bringing-the-best-of-azure-and-postgresql-innovation-to/ba-p/2382316) — Microsoft wants Azure to be ‘the best cloud’ for Postgres and at its latest developer event has unveiled a free, 12 month ‘offer’ for their _Flexible Server_ Azure Database for PostgreSQL service, new security capabilities, and the latest Citus updates. Sunil Kamath [Speeding Up Recovery with pgBackRest](https://seiler.us/2021-05-23-speeding-up-pgbackrest-recovery/) — Some tips on tweaking [pgBackRest’s](https://pgbackrest.org/) settings to make WAL restore and recovery a bit faster. Don Seiler [📈 Analyzing Cryptocurrency Trends: Step-by-Step Tutorial](https://tsdb.co/analyze-cryptocurrency-tutorial) — [Learn how to explore crypto prices over time](https://tsdb.co/analyze-cryptocurrency-tutorial), complete with a sample dataset & 5+ SQL queries to jumpstart your analysis. Timescale sponsor [Getting Started with Columnar Compression in Hyperscale (Citus) on Azure](https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/postgres-with-columnar-compression-in-hyperscale-citus-on-azure/ba-p/2373870) — Further to recent announcements regarding its Citus horizontal scaling system and its new columnar storage feature, this is a practical ‘how to’ on starting to use columnar storage on Azure specifically. Jeff Davis (Microsoft) [Setting Up Streaming Replication for Postgres 13](https://www.cybertec-postgresql.com/en/setting-up-postgresql-streaming-replication/) — _“If you are looking to set up streaming replication for PostgreSQL 13, this is the page you have been looking for.”_ Hans-Jürgen Schönig [Forget SQL vs NoSQL: Get the Best of Both Worlds with JSON in Postgres](https://arctype.com/blog/json-in-postgresql/) — Preaching to the choir here, perhaps. Derek Xiao [Porting An Array Length Function from Oracle's PL/SQL to PL/pgSQL](https://www.migops.com/blog/2021/05/19/porting-array-length-from-oracle-plsql-to-postgresql-plpgsql/) Dileep Kumar **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|*)