--- title: "A vacuum-free future for Postgres?" publication: "Postgres Weekly" issue: 515 published_at: "2023-07-19" canonical_url: "https://postgresweekly.com/issues/515" --- Plus Citus gains schema-based sharding, a new UK Postgres event, more Postgres podcasts, and Aurora gains pgvector support. | #​515 — July 19, 2023 [Web Version](https://postgresweekly.com/issues/515) Together with [![Epsio\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_345,h_155/e_make_transparent/co_white,e_outline:10/mmeowbxba1ikxyqjznii.png)](https://epsio.io/?utm_source=newsletter&utm_medium=email&utm_campaign=pg-weekly-jul) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/pdiatnvihasxcycz1zme.jpg)](https://www.citusdata.com/blog/2023/07/18/citus-12-schema-based-sharding-for-postgres/) [Citus 12: Schema-Based Sharding for Postgres](https://www.citusdata.com/blog/2023/07/18/citus-12-schema-based-sharding-for-postgres/) — [Citus](https://github.com/citusdata/citus) has been around doing its ‘distributed Postgres’ thing for years now, but this is a huge release that introduces _schema-based sharding._ Schema-based sharding contrasts to Citus’s original row-based sharding approach by allowing you to shard in a broader way - particularly handy for multi-tenant SaaS apps, to give just one example. Citus Data [![\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_345,h_155/e_make_transparent/co_white,e_outline:10/mmeowbxba1ikxyqjznii.png)](https://epsio.io/?utm_source=newsletter&utm_medium=email&utm_campaign=pg-weekly-jul) [Instant Results for Complex Queries with Epsio's Incremental Materialized Views](https://epsio.io/?utm_source=newsletter&utm_medium=email&utm_campaign=pg-weekly-jul) — Reduce query latencies and workload costs by orders of magnitude by integrating Epsio into your existing database. Epsio sponsor [No More VACUUM? No More Bloat?](https://www.orioledata.com/blog/no-more-vacuum-in-postgresql/) — OrioleDB is a bold extension with bold aims, including eventually becoming part of Postgres core. It’s an alternative engine for Postgres that can eliminate bloat and the need for ongoing vacuuming of tables. This post does a good job of explaining what it is, how it works, and why you might use it, but bear in mind it’s still somewhat experimental. Oriole DB Inc. [Working with Time Series in Postgres](https://alexplescan.com/posts/2023/07/15/postgres-timeseries/) — Of course, you _could_ reach for TimescaleDB or the like, but for modest use cases, Postgres most likely already has the powers you need to temporally slice and dice your data. Alex Plescan **IN BRIEF:** - 📅 🇬🇧 [PGDay UK](https://2023.pgday.uk/) is a new event being held by PostgreSQL Europe this September 12 in, _surprise, surprise_, London, UK 😁 - Amazon Aurora has added [support for Postgres 15.3, 14.8, 13.11, 12.15 and 11.20.](https://aws.amazon.com/about-aws/whats-new/2023/07/amazon-aurora-postgresql-additional-versions/) It has also [added support for pgvector.](https://aws.amazon.com/about-aws/whats-new/2023/07/amazon-aurora-postgresql-pgvector-vector-storage-similarity-search/) - Supabase had a go at [benchmarking pgvector 0.4.](https://supabase.com/blog/pgvector-performance) - Bytebase had a go at [comparing Postgres and MySQL.](https://www.bytebase.com/blog/postgres-vs-mysql/) - Heroku had a go at [improving their Postgres extensions experience](https://blog.heroku.com/improving-the-heroku-postgres-extension-experience) by returning to supporting adding extensions to the `public` schema. - 📅 The [schedule for the PASS Data Community Summit 2023 is now live.](https://passdatacommunitysummit.com/sessions/) The usually SQL Server-focused event is branching out and there are a surprising number of Postgres talks this year. 🎧 [_Path to Citus Con_: A Postgres Podcast](https://www.citusdata.com/blog/2023/07/14/say-hello-to-path-to-citus-con-podcast/) — A podcast from the Citus Data team at Microsoft that was created to showcase speakers for their popular Citus Con event but which, now, is being presented as more of a general Postgres podcast. The [▶️ latest episode](https://pathtocituscon.transistor.fm/episodes/my-favorite-ways-to-learn-more-about-postgresql-with-grant-fritchey-and-ryan-booz) features Grant Fritchey and Ryan Booz talking about their favorite ways to learn about Postgres. Citus Data [Postgres.fm](https://postgres.fm/) also continues to be a fantastic show. Their [latest episode covered connection poolers](https://postgres.fm/episodes/connection-poolers) like PgBouncer and PgCat. [Zero-Downtime Postgres Cutovers at Instacart](https://tech.instacart.com/zero-downtime-postgresql-cutovers-e6f16090fabf) — An explanation of how Instacart keeps their large fleet of RDS Postgres servers up to date without downtime. Nicholson, Tanner, and Montagna (Instacart) [How to Create and Run Postgres Regression and TAP Tests](https://www.highgo.ca/2023/07/17/putting-postgres-to-the-test-how-to-create-and-run-regression-and-tap-tests/) — One for those working directly on Postgres. Tristen Raab Code and Tools [Ora2Pg 24.0: It's No Longer Just for Oracle](https://www.postgresql.org/about/news/ora2pg-240-have-been-released-2671/) — [Ora2Pg](https://ora2pg.darold.net/) is a long standing tool to assist with Oracle Database to Postgres migrations, but it has now added support for migrating from SQL Server too. Gilles Darold [An Open Source Alternative to PostgreSQL in the Cloud. Start for Free With $300 in Credits.](https://www.enterprisedb.com/accounts/register/biganimal?utm_source=postgresweekly&utm_medium=link&utm_campaign=GL-DS--BigAnimal-DSS) EDB BigAnimal sponsor [pg_cirrus Beta 1: Easy Postgres Cluster Setup](https://www.postgresql.org/about/news/announcing-the-release-of-pg_cirrus-hassle-free-postgresql-cluster-setup-2669/) — A simple bringing together of Python and Ansible for setting up a three node cluster with one primary and two standbys, complete with streaming replication and load balancing with [basic instructions here.](https://stormatics.tech/how-to-use-pg_cirrus-to-setup-a-highly-available-postgresql-cluster) Stormatics [What's New in PostgREST v11.1?](https://supabase.com/blog/postgrest-11-1-release) — [PostgREST](https://github.com/PostgREST/postgrest) is a Haskell app that serves up a RESTful API from any existing Postgres database. It doesn’t require Supabase, but this is Supabase’s take on the update. Steve Chavez (Supabase) - [FerretDB 1.6](https://github.com/FerretDB/FerretDB/releases/tag/v1.6.0) ↳ Feels like MongoDB, sits atop Postgres. - [Credcheck 2.1](https://www.postgresql.org/about/news/credcheck-version-21-released-2676/) ↳ Validates Postgres user credentials. - [PGSpider 3.1.0](https://www.postgresql.org/about/news/high-performance-sql-cluster-engine-pgspider-310-released-2675/) ↳ Toshiba's SQL cluster engine for distributed big data. - [PostGIS 3.4.0 Beta 1](https://postgis.net/2023/07/PostGIS-3.4.0beta1/) - [PgManage 1.0b2](https://www.commandprompt.com/blog/pgmanage-10b2-released/) **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|*).