--- title: "Embrace, extend, and open source? Citus opens up even more." publication: "Postgres Weekly" issue: 460 published_at: "2022-06-22" canonical_url: "https://postgresweekly.com/issues/460" --- Plus Michael Stonebraker says Postgres needs time travel, and Postgres pops up inside a Python package. | #​460 — June 22, 2022 [Web Version](https://postgresweekly.com/issues/460) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/ctmux0lxk5sgijmm3kkf.jpg)](https://www.citusdata.com/blog/2022/06/17/citus-11-goes-fully-open-source/) [Citus 11 for Postgres Goes _Fully_ Open Source](https://www.citusdata.com/blog/2022/06/17/citus-11-goes-fully-open-source/) — Citus, a Postgres extension for horizontal scaling, was first open sourced _six years ago_ but with the common business model of offering an extended ‘enterprise’ version for money. No longer. Now there’s only one Citus version and it’s all open source, so features like tenant isolation, non-blocking shard rebalancing, and others are now open to all. This is a huge release and well explained in this post. Marco Slot (Citus Data) [Postgres 14.4 Released](https://www.postgresql.org/about/news/postgresql-144-released-2470/) — Last week we warned an imminent Postgres 14 update was coming to resolve a nasty bug around silent corruption of indexes when using `CREATE INDEX CONCURRENTLY` or `REINDEX CONCURRENTLY` and now it’s here. You can use `pg_amcheck` to see if you were affected. Non Postgres 14 users remain unaffected. PostgreSQL Global Development Group [![\](https://copm.s3.amazonaws.com/5258279f.png)](https://blog.yugabyte.com/postgresql-timestamps-timezones/?utm_source=postgres_weekly&utm_medium=media_buy&utm_campaign=blog_timestamps_timezones) [Timestamps & Timezones: What You Need to Know & What You Don’t](https://blog.yugabyte.com/postgresql-timestamps-timezones/?utm_source=postgres_weekly&utm_medium=media_buy&utm_campaign=blog_timestamps_timezones) — Some PostgreSQL programmers are daunted by the date and time data types, and by the effect of the session’s timezone setting on operations. YugabyteDB’s YSQL can result in the same experience. Read about a careful and exhaustive study recently conducted on this topic. YugabyteDB sponsor **QUICK BITS:** - From Postgres Vision 2022 comes [▶️ a recording of a panel discussion](https://vyruss.org/blog/postgresql-community-panel-upgradability-postgres-vision-2022.html) about Postgres upgradability. - Michael Stonebraker (no introduction needed, we hope?) suggests Postgres [needs to revisit the idea of making time travel a core feature.](https://www.theregister.com/2022/06/14/database_from_the_1980s_needs/) - Amazon Aurora [now supports](https://aws.amazon.com/about-aws/whats-new/2022/06/amazon-aurora-postgresql-supports-lo-module/) Postgres's [LO / Large Objects module.](https://www.postgresql.org/docs/current/lo.html) - A quick look at [some of the Postgres projects being worked on](https://andreas.scherbaum.la/blog/archives/1115-PostgreSQL-Project-GSoC-2022.html) over Google's Summer of Code. Good luck to everyone involved. [How to Find and Stop Running Queries on Postgres](https://adamj.eu/tech/2022/06/20/how-to-find-and-stop-running-queries-on-postgresql/) — Postgres is seizing up under the pressure of some troublesome queries or resource constraints and you need to take control fast.. how can you stop those queries without bringing the whole deck of cards down? This post goes into more detail than you’d expect on poking about and taking charge of Postgres’s backend processes. Adam Johnson [How TimescaleDB 2.7 Makes its Data Aggregation Better and Faster](https://www.timescale.com/blog/how-we-made-data-aggregation-better-and-faster-on-postgresql-with-timescaledb-2-7/) — The folks at Timescale are certainly putting in the work to make it a compelling option for time-series workloads. This post digs deep into some benchmarks showing off just how much faster the new 2.7 release is versus 2.6 with some queries up to 44,000x faster (while typically requiring 60% less storage). Ryan Booz (Timescale) [Achieving High Uptime with Flexible Server PostgreSQL HA](https://techcommunity.microsoft.com/t5/azure-database-for-postgresql/achieve-high-uptime-with-flexible-server-postgresql-ha/ba-p/3530443) — The “HA” isn’t laughter but _High Availability_ and Azure has introduced a couple of new HA capabilities to its slightly wordy _Database for PostgreSQL Flexible Server_ service. Sridhar Ranganathan (Microsoft) **🔧 Code and Tools:** [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/dnhui7eyawfeqk0l5vwn.jpg)](https://explain.dalibo.com/) [The Dalibo Postgres Execution Plan Visualizer](https://explain.dalibo.com/) — Give this the output from `EXPLAIN ANALYZE` and get a better view at what Postgres plans to do with your query. Along similar lines to the better known [explain.depesz.com](https://explain.depesz.com/) but presents the results in a rather different way, so it’s worth trying both. This has been around a while but has seen some recent updates. Dalibo [Quickly Identify and Address Postgres Queries with Datadog Database Monitoring](https://www.datadoghq.com/dg/monitor/ts/databases-benefits-ts/?utm_source=advertisement&utm_medium=newsletter&utm_campaign=dg-cooperpress-applications-ww-postgres-b-databasemonitoring-tshirt) Datadog Database Monitoring sponsor [pg_squeeze: An Extension to Fix Table Bloat](https://www.cybertec-postgresql.com/en/products/pg_squeeze/) — While it’s not a replacement for vacuuming, it boasts being a handy extension to go a step further and gain even more space improvements on a table. CYBERTEC [pgCluu: Postgres Performance Monitoring and Auditing Tool](https://pgcluu.darold.net/) — A two part tool that collects statistics from a running Postgres cluster and then presents performance information for you to inspect. [GitHub repo.](https://github.com/darold/pgcluu) Gilles Darold [Cloudflare Workers Postgres Client](https://github.com/bubblydoo/cloudflare-workers-postgres-client) — Considered ‘experimental’ for now. BubblyDoo **OTHER RELEASES:** [sqlx 0.6](https://github.com/launchbadge/sqlx) – Async, pure Rust SQL toolkit. [pg-boss 7.4](https://github.com/timgit/pg-boss) – Queueing jobs in Node.js using Postgres. [mikro-orm 5.2.1](https://github.com/mikro-orm/mikro-orm) – TypeScript ORM for Node.js based on Data Mapper. [ruby-pg 1.4](https://github.com/ged/ruby-pg) – Postgres client library for Ruby. [Ipx.](https://postgresweekly.com/open/460/*|UID|*?ipx=t) **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|*)