--- title: "Postgres 13 beta 1 released" publication: "Postgres Weekly" issue: 357 published_at: "2020-05-27" canonical_url: "https://postgresweekly.com/issues/357" --- This week's Postgres news, views, and tools. #357 — May 27, 2020 [Read on the Web](https://postgresweekly.com/issues/357) 📺 BTW, if you're in the mood for some live Postgres talks, be sure to check out the PGCon item as it's taking place _right as we send this issue._ 😁 Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/v1590578119/r9cos6ub8ngudxno6wuy.jpg)](https://www.ongres.com/blog/explain_analyze_may_be_lying_to_you/) [`EXPLAIN ANALYZE` May Be Lying to You](https://www.ongres.com/blog/explain_analyze_may_be_lying_to_you/) — It’s not often a Postgres article starts off leaning on Heisenberg’s uncertainty principle, but Álvaro looks at situations where analyzing a query might well be distorting what really happens behind the scenes.. Álvaro Hernández [PostgreSQL 13 Beta 1 Released](https://www.postgresql.org/about/news/2040/) — The [draft release notes](https://www.postgresql.org/docs/13/release-13.html) (we linked these last week too) are available, but the biggest improvements are to partitioning, B-tree indexes, incremental sorting, parallel `VACUUM`ing, client connection security, and Windows operability. PostgreSQL Global Development Group [![\](https://copm.s3.amazonaws.com/ff848354.jpg)](https://www.cockroachlabs.com/product/whats-new/?utm_campaign=cooperpress-2020-Q2&utm_source=postgresweekly&utm_medium=newsletter&utm_content=primary-postgres-20-1) [Announcing CockroachDB 20.1: Build Fast, and Build to Last](https://www.cockroachlabs.com/product/whats-new/?utm_campaign=cooperpress-2020-Q2&utm_source=postgresweekly&utm_medium=newsletter&utm_content=primary-postgres-20-1) — Meet the resilient, scalable SQL database, now with improved PostgreSQL compatibility. Bring effortless scalability and bulletproof resilience to all your applications. Try free for 30 days → Cockroach Labs sponsor [The PGCon 2020 Conference is Streaming.. Now!](https://www.pgcon.org/2020/) — Like many events, Postgres’s annual PGCon is virtual and taking part right now with three streaming rooms, Zoom, and an IRC chat across May 26-29. [Full schedule](https://www.pgcon.org/events/pgcon_2020/schedule/), if you have time - the main talks start shortly after we're sending this issue :-) PGCon [Do You Really Need a Tool for Partition Management?](https://www.cybertec-postgresql.com/en/partition-management-do-you-really-need-a-tool-for-that/) — Table partitioning is a way to divide tables into more manageable parts and can also speed up queries. Postgres has provided features for since this version 10 but there’s not a lot of _tooling_ around it.. but do we need any? Kaarel Moppel [Hidden / Implicit Table Columns](https://www.highgo.ca/2020/05/20/phoney-table-columns-in-postgresql/) — Did you know that behind the scenes of each table there are several hidden columns including `tableoid`, `cmax` and `ctid`? This post looks at what their contents represent. muhammad usama [Postgres Tips for Optimizing Django and Python Performance](https://www.citusdata.com/blog/2020/05/20/postgres-tips-for-django-and-python/) — A broad summary up based on [a (rather more detailed) talk Louise gave](https://www.youtube.com/watch?v=dyBLGjCQJHs&feature=youtu.be) for PyCon 2020. Louise Grandjonc [Postgres 13 Adds `FETCH FIRST WITH TIES`](http://sqlservercode.blogspot.com/2020/05/postgresql-adds-fetch-first-with-ties.html) Denis Gobo [Inspecting Command Tags and Events in Event Triggers](https://fluca1978.github.io/2020/05/26/PostgreSQLEventTriggerDemo.html) — If you didn’t see it, we interviewed Luca in [issue 352.](https://postgresweekly.com/issues/352) Luca Ferrari [Learn About the Top 6 Events to Monitor in Your Database Logs](https://pganalyze.com/ebooks/monitoring-postgres-logs?utm_source=PostgresWeeklySecondary05272020) — In this eBook, we walk you through the most important Postgres log events for monitoring query performance and preventing downtime. pganalyze sponsor ▶[What Developers Are Doing with Postgres and MySQL On Azure](https://youtu.be/IM6RB3USbcI) — A 30 minute talk and discussion from last week’s virtual Microsoft Build conference. Quite high level. Andrea Lam and Samay Sharma [Zapatos: Zero-Abstraction Postgres for TypeScript](https://jawj.github.io/zapatos/index.html) — Build TypeScript schemas for Postgres tables, get the right types for things going into and coming out of Postgres, and so much more. Some _serious_ time has been put into the thorough docs here, by the way. George MacKerron [pgagroal 0.7.0: A High Performance Postgres Connection Pool](https://agroal.github.io/pgagroal/) — 0.7 brings Prometheus support, remote management, and the ability to disconnect idle clients after a chosen number of seconds. Red Hat Inc. 🗓**Upcoming Online Events** - [Postgres Pulse](https://www.enterprisedb.com/postgres-pulse) - weekly at 11am ET each Monday. Weekly Zoom-based sessions with folks like Bruce Momjian, Vibhor Kumar, and other people at EnterpriseDB. - [Postgres Vision 2020](https://www.postgresvision.com/) on June 23-24. A full attempt at an online Postgres conference across multiple days with multiple tracks. Curated by [Cooperpress](https://cooperpress.com/), [Peter Cooper](https://twitter.com/peterc), and [Craig Kerstiens](https://twitter.com/craigkerstiens). [Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) © Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom