--- title: "Amazon Aurora Serverless v2 now available" publication: "Postgres Weekly" issue: 452 published_at: "2022-04-27" canonical_url: "https://postgresweekly.com/issues/452" --- Plus all of the Citus Con talks, and making maps from data in Postgres with PostGIS and pgAdmin. | #​452 — April 27, 2022 [Web Version](https://postgresweekly.com/issues/452) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/nar6gdqvvkzgbxysdidw.jpg)](https://aws.amazon.com/blogs/aws/amazon-aurora-serverless-v2-is-generally-available-instant-scaling-for-demanding-workloads/) [Amazon Aurora Serverless v2 Now Generally Available](https://aws.amazon.com/blogs/aws/amazon-aurora-serverless-v2-is-generally-available-instant-scaling-for-demanding-workloads/) — Aurora is AWS’s Postgres (and MySQL) _compatible_ managed database system and has long had a serverless ‘pay as you go’ variant. Version 2 of Aurora Serverless takes things up a notch in terms of scalability and granularity providing ‘instant’ and non-disruptive scaling when loads suddenly change. Marcia Villalba (AWS) [Fuzzy Name Matching in Postgres](https://blog.crunchydata.com/blog/fuzzy-name-matching-in-postgresql) — Paul loads 50,000 fake names into a Postgres table then demonstrates some ways to find names that match certain requirements including those that _sound_ similar when spoken aloud. Paul Ramsey [![\](https://copm.s3.amazonaws.com/e0d95a72.png)](https://pganalyze.com/ebooks/postgres-indexing?utm_source=PostgresWeeklyPrimary04272022) [Free eBook: Effective Indexing in Postgres](https://pganalyze.com/ebooks/postgres-indexing?utm_source=PostgresWeeklyPrimary04272022) — Learn how to create the best Postgres index for your queries. We provide a deep dive into index types, operators, data types and more. Creating the right indexes can often improve your query performance by 10x or even 100x. pganalyze sponsor [Eight Things You Probably Didn't Know PostgreSQL Can Do](https://www.enterprisedb.com/blog/8-cool-interesting-facts-things-postgresql-can-do) — This isn’t new, but somehow we didn’t see it at the time, and it’s an interesting list. If you’ve spent much time digging around in Postgres you probably _do_ know these things, but casual day to day users may not. Thom Brown ▶[_All_ of the Citus Con Talks and Replays](https://www.citusdata.com/cituscon/2022/schedule/#all-videos) — Two weeks ago we linked to a playlist of videos from the recent [Citus Con](https://www.citusdata.com/cituscon/2022/) online Postgres conference, but now the official Citus Con site has the videos linked from its own schedule in an easier to discover way, plus you can now see _all_ 38 sessions versus just 20 before. Citus Data / Microsoft ▶[PostgreSQL – More Relevant Than Ever](https://www.youtube.com/watch?v=rz6XvfqNa7Q) — One of the aforementioned Citus Con talks. Magnus, of the Postgres core team, spoke about how despite Postgres’s age, it’s more relevant in the database sphere than ever. This is a great talk to catch up on some history and the broad position and mindset of the Postgres ecosystem. Magnus Hagander [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/wjkicxaw4nqjnxbfsiso.jpg)](https://t.co/wQgQBxPXwy) [Mapping Fracking Wells in Colorado with Postgres](https://t.co/wQgQBxPXwy) — A practical look at using Postgres, pgAdmin, and PostGIS to create maps from data. Richard Peterson [Postgres 14 B-Tree Index: Reduced Bloat with Bottom-Up Deletion](https://www.percona.com/blog/postgresql-14-b-tree-index-reduced-bloat-with-bottom-up-deletion/) — A look at how Postgres 14 is more efficient in deleting obsolete versions of index tuples in B-Tree indexes, resulting in smaller total index sizes. Hamid Akthar [Formatting SQL Code with pgFormatter in Vim](https://www.endpointdev.com/blog/2022/04/formatting-sql-vim-pgformat/) — Last week, we learnt how to format SQL code [with pgFormatter in Emacs](https://fluca1978.github.io/2022/04/13/EmacsPgFormatter.html), so it’s no surprise to see Vim turn up as an option too :-) Josh Tolley [Three Tips For Startups Who Chose CockroachDB Over Postgres](https://www.cockroachlabs.com/blog/tips-for-startups/) — We don’t want you to jump ship, but it’s often interesting to contrast and compare (and pretty much essential if you’re a CTO or influencing technology choices at your company). Theodore Hyman and Cassie McAllister (Cockroach Labs) **🔧 Code and Tools:** [pg_party 1.4: PostgreSQL Partitioning for Ruby on Rails' Active Record](https://github.com/rkrage/pg_party) — AR migrations and helpers for creating and managing table partitions. Now has full Postgres 11+ feature support and supports sub-partioning. Ryan Krage [AI Caching for Postgres, Scale Effortlessly in Minutes](https://www.polyscale.ai/platform/) PolyScale.ai sponsor [PostGIS 2.5.6: A Bug Fix Release](http://www.postgis.net/2022/04/21/postgis-2.5.6/) — Plus [v2.4.10](http://www.postgis.net/2022/04/24/postgis-2.4.10/) – an end-of-life release for the 2.4 branch. Regina Obe [pg2rs: Create Rust Source Code Entities from Postgres Tables](https://github.com/spanasik/pg2rs) Stanislav [Reshape 0.6: A Zero-Downtime Schema Migration Tool for Postgres](https://github.com/fabianlindfors/reshape) Fabian Lindfors ▶[Discussing Postgres.js with Rasmus Porsager](https://changelog.com/jsparty/221) — [Postgres.js](https://github.com/porsager/postgres) is a fast, fully featured Postgres client library for both Node.js and Deno. In this 50 minute interview, he talks about its creation, as well as Postgres in general. JS Party Podcast podcast **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|*)