https://www.cybertec-postgresql.com/en/handling-graphs-with-sql-pgq-in-postgresql/
Handling Graphs with SQL/PGQ in Postgres 19 — Postgres 19 is adding support for SQL/PGQ, so you can declare a property graph over tables and pattern-match with Cypher-like  MATCH (a IS person)-[IS knows]->(b IS person) queries. It’s all handled by the query rewriter, so a graph pattern becomes a normal relational query.
3 months ago
https://www.tigerdata.com/events/webinar-cern-2026
95% Less Storage. 40% Faster Analytics. CERN on Postgres — CERN's Large Hadron Collider generates hundreds of GB of time-series data daily. In this live webinar, their engineers walk through how they modernized a legacy archiving stack with TimescaleDB. June 25, 9 AM ET.
3 months ago
https://www.pgedge.com/blog/why-postgres-lacks-transparent-data-encryption
🔓 Why Postgres Lacks Transparent Data Encryption — Many other databases have it, but in Postgres you need to lean on third party services or the pg-tde extension. Why? Shaun digs into old discussions about the feature, and finds the biggest problem is defining what problem that TDE actually needs to solve.
3 months ago
https://www.valerieparhamthompson.com/posts/extended-statistics-postgres/
Helping the Planner Help You — When two columns are correlated, Postgres assumes they’re independent and the planner’s row estimates go badly wrong. A practical tour of CREATE STATISTICS and the better query plans it unlocks.
#performance tuning
#data engineering
#query optimization
3 months ago
https://planetscale.com/blog/database-egress
Egress Problems and Where to Find Them — If your database is running in someone else’s datacenter, data egress and associated costs are important to control. Simeon shares tips on how to get the numbers down, along with some PlanetScale-specific advice.
3 months ago
https://github.com/xataio/deltax
DeltaX (δx): Fast Time-Series Extension for Postgres — A new columnar storage extension for time-series data from Xata that uses only regular Postgres tables, so things like replication, crash recovery, backups, and pg_dump work as they usually would. Here’s how it works.
3 months ago
https://github.com/viggy28/streambed
Streambed: Stream Postgres to Iceberg on S3 — Streams WAL via logical replication, writes Parquet to S3, and commits Iceberg metadata. You can then query with plain psql thanks to a built-in wire-protocol server.
3 months ago
https://github.com/bruin-data/ingestr
ingestr v1: Copy Data to and from Databases in One Command — A Go-powered tool to move data (with incremental append/merge support) between a myriad of sources and destinations (Postgres included) without writing code.
3 months ago
https://www.youtube.com/watch?v=YPObBOwIrHk
Postgres at 30: A Chat With Its Creator — With Postgres turning 30 this year, here’s a treat: a wide-ranging interview with Mike Stonebraker, the man who started the Postgres project. He covers how Postgres came to be, where he thinks Google and Amazon get databases wrong, and what he’s building next.
#autos & vehicles
3 months ago