Amazon Aurora Serverless v2 Now Generally Available — 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 — 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

Free eBook: Effective Indexing in Postgres — 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 — 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

Mapping Fracking Wells in Colorado with Postgres — 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 — 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 — Last week, we learnt how to format SQL code with pgFormatter in Emacs, 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 — 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)

pg_party 1.4: PostgreSQL Partitioning for Ruby on Rails' Active Record — 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

PolyScale.ai sponsor