~postgresweekly | Issue 587 - Microsoft's BSON document NoSQL database on Postgres (8)

ChartDB: Open Source Database Schema Diagram Editor — Create a new schema from scratch or quickly import your existing one. Supports Postgres, MySQL, SQL Server, SQLite, and more, and is built in TypeScript. You can deploy it for yourself or try an online demo here. AGPL licensed.

Just Because You’re Getting an Index Scan, Doesn't Mean You Can’t Do Better — If you see index scans when reviewing query plans, you might think you’re on the right path to a high performing query, but there’s more juice left for the squeezing, says Michael. Useful tips here.

DocumentDB: Microsoft Brings More NoSQL to Postgres — Not to be confused with the proprietary Amazon DocumentDB, this DocumentDB is an MIT-licensed document-based NoSQL engine built on top of Postgres that Microsoft use internally for Azure Cosmos DB for MongoDB.

🤖 Automating Data Summarization in Postgres with Claude — Timescale shows how to bring pgvector together with their pgai tooling to have Postgres reach out to Anthropic’s Claude AI for summarization tasks without any external scripting.

commit_delay for Better Performance: A Postgres Benchmark — Laurenz shares benchmark results highlighting the performance wins gained by using the commit_delay and commit_siblings parameters to group WAL flushes and ultimately optimize transactional workloads.

Replacing Oracle Hints: Best Practices with pg_hint_plan — Oracle Database users can use ‘hints’ to guide the query optimizer’s decision making process, and you can reproduce the idea in Postgres with pg_hint_plan. Lukas explains when you might use hints and how Oracle hints can be mapped to Postgres.

DB Fiddle: An Online SQL Database Playground — It’s been a couple of years since I linked to this useful tool that offers numerous database systems in an online sandbox of sorts (including Postgres versions 9.4 through to 17). While a local database is always better for big experiments, if you want to check syntax changes before versions or test queries against older Postgres...

POSETTE 2025: Call for Proposals (CFP) is Open! — POSETTE: An Event for Postgres, a free & virtual developer event organized by the Postgres team at Microsoft, is happening June 10-12. The CFP is open until February 9. New and experienced speakers are encouraged to submit! Get the details.