Brandur digs into one of Postgres 17's updates that make b-tree index scans faster. He's tested performance against the Crunchy Bridge API and the results are pretty impressive.
Indico Data had database costs growing exponentially on Amazon RDS. Even with adding staff to self-manage on Crunchy Postgres for Kubernetes, their move to Crunchy Data reduced costs and streamlined their workflow.
Paul walks through some sample code to use PostGIS and pgRouting with Overture maps. This uses the new spatial analytics capabilities of Crunchy Bridge which can connect to Postgres to a public S3 data stores.
Elizabeth has some sample queries and explanations for window functions like running totals, lag/lead, rolling averages, and more. This post also has an in-browser tutorial.
