#​429 — November 3, 2021

Web Version

Postgres Weekly

Goodbye Microsoft SQL Server, Hello Babelfish — Almost a year ago, in issue 384, we covered Amazon’s unveiling of Babelfish, a SQL Server to Postgres ‘translation layer’ – it’s now generally available for Aurora, but has also been released as open-source on GitHub, though it’s still early days in that regard.

Sébastien Stormacq (AWS)

📣  Regarding the above, there's also an announcement post for the open source Babelfish for PostgreSQL project that digs more into that side of things.

How Partial, Covering, and Multicolumn Indexes May Slow Down UPDATEs — Despite the findings, it can also depend upon your ratio of SELECT to UPDATE commands and whether you’d trade off the performance for one against the other.

Nikolay Samokhvalov

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.

pganalyze sponsor

How We Deconstructed the Postgres Planner to Find Indexing Opportunities — In order to build the new pganalyze Index Advisor, the team at pganalyze set about extracting Postgres’s query planner into a standalone library so they could interrogate it more precisely. This post goes into depth about how they did it and how the index advisor uses it too.

Lukas Fittl

Implementing a Forth-Like Interpreter with PL/pgSQL — Last week Phil covered the basics of PL/pgSQL but this week goes into quirkier places.

Phil Eaton

📣  EDB has announced BigAnimal™, what it boasts is the first managed Postgres cloud database "with compatibility for Oracle database technology".

Configuring TCP Keepalive for a Better Postgres Experience — The idea is to better keep idle database connections open as well as to detect broken connections.

Laurenz Albe

Vehicle Routing Optimization with Amazon Aurora — A walk through using the Postgres-flavored variant of Aurora to store map and toplogy data to provide geospatial routing functionality at scale. If you’ve got a lot of vehicles to go a lot of places in a fixed amount of time, this is the sort of work you’d be doing.

Nicola Pietroluongo (AWS)

Analyze Millions of NFT Sales on OpenSea using Postgres and TimescaleDB — I haven’t really gotten into NFTs and the like, but if it’s an area that interests you, the Timescale folks have created a tutorial and ‘kit’ for analyzing NFT data from one of the largest NFT marketplaces.

Sewrathan and Toth (Timescale)

Never Worry About Your Database Again

CockroachDB Serverless sponsor

Scandinavian Airlines' (SAS) Transition to Postgres on Azure — A new case study from Microsoft with Scandinavia’s leading airline now running their booking app on Azure Kubernetes Service (AKS) backed by Azure Database for PostgreSQL - Flexible Server.


ScalikeJDBC: A Tidy SQL DB Access Library for Scala Developers — Not solely for Postgres, but if you’re a Scala developer it’s an attractive option.


Functional Dependencies in SQL's GROUP BY
Lukas Eder