Announcing new open source releases, exploring projects, sharing how we approach FOSS, and supporting communities around the world.
- Tweets 2,299
- Following 145
- Followers 82,152
- Likes 735
ALT Slide 01/04 of a dark-themed Google Open Source technical carousel titled "UPSTREAM ENGINEERING // POSTGRESQL 20: Shipping PostgreSQL 20: Inside Our 2026 Upstream Core & Extension Fixes." Subtitle: "From queryable logical replication conflict tables to single-check sequential scans and superuser-free pg_dump on Large Objects." Features a group photograph of attendees at Postgres Bangalore (PGBLR) Meetup 10 alongside the Google Cloud PostgreSQL engineering team, credited to Dilip Kumar (PostgreSQL Significant Contributor) with Nitin Motiani, Robert Pang, Aniket Jha, and Sunaina Punyani. Footer: opensource.googleblog.com β’ goo.gle/postgresql-2026-highlights.
ALT Slide 02/04 titled "LOGICAL REPLICATION & ACCESS CONTROL: Queryable Conflict Logs & Superuser-Free Large Objects." Displays two dark terminal windows with syntax-highlighted SQL. Terminal 1 ("psql β Logical Replication (PostgreSQL 20 Roadmap)") shows: CREATE SUBSCRIPTION prod_active_sub CONNECTION 'host=primary.db dbname=prod' PUBLICATION core_tables_pub WITH (conflict_log_destination = 'table'); followed by SELECT relid, conflict_type, remote_xid FROM pg_conflict.pg_conflict_log_'%sublid%';. Terminal 2 ("upstream_patches.sql β Least-Privilege & Concurrency") shows: GRANT pg_read_all_data TO backup_role; (enabling superuser-free pg_dump on Large Objects) and REINDEX TABLE CONCURRENTLY orders_with_deferrable_pk; (preserving DEFERRABLE constraint semantics across rebuilds via INDEX_CREATE_DEFERRABLE).
ALT Slide 03/04 titled "SCAN OPTIMIZATION & ECOSYSTEM FIXES: Core Scan Optimization & Ecosystem Memory Safety." Top callout banner ("CORE ENGINE OPTIMIZATION (TABLE_SCAN_NEXT)") reads: "CheckXidAlive: N Tuple Checks -> 1 Check/Scan β Eliminates redundant per-tuple transaction liveness checks in table_scan_next() by verifying CheckXidAlive once per sequential scan." Below is a 2x2 technical fix matrix: (1) STANDBY PROMOTION: pg_promote() Timeout Fix (fixed premature standby promotion timeouts under heavy load); (2) DSM HASH CLEANUP: dshash Detach Segfault (prevented segmentation faults when processes exit after FATAL); (3) PLPGSQL_CHECK & PGTT: PG14 LWLock & UAF Fixes (added shmem_request_hook LWLock registration & deep-copied plans); and (4) PGFINCORE PR #12 & #13: Buffer & Pointer Safety (fixed off-by-one buffer check and dangling pointer dereference).
ALT Slide 04/04 titled "COMMUNITY & ECOSYSTEM // @GOOGLEOSS: Built Upstream With the PostgreSQL Community." Box 1 ("UPSTREAM PROJECTS & MAINTAINERS") credits Core Engine: PostgreSQL Global Dev Group (@postgresql), plpgsql_check: Pavel Stehule (@pavel_stehule β okbob/plpgsql_check), pgfincore: CΓ©dric Villemain (klando/pgfincore β PR #12 & #13), and pgtt: Gilles Darold (darold/pgtt β Global Temp Tables). Box 2 ("UPSTREAM ROADMAP & COMMUNITY DISCUSSIONS (PGSQL-HACKERS)") lists Conflict Resolution (auto-resolving via PG 20 conflict tables), Active-Active Replication (multi-master conflict logging foundation), Extension Hardening (plpgsql_check, pgfincore & pgtt patches), and Get Involved (test patches & share feedback on pgsql-hackers). Call-to-action banner: "Full Commit Walkthrough & Extension Patch Links β β First reply below: goo.gle/postgresql-2026-highlights."
ALT Slide 01/04 of a Google Open Source carousel: "THIS WEEK IN OPEN SOURCE #17 // SEPT 24, 2026: Sustaining an $8.8T Ecosystem: Registry Royalties, Grid ROI, & Hardened AI Supply Chains." Subtitle: "5 essential open source reads + 8 fall community conferences across supply-chain economics, AI post-mortems, and open science." Features a portrait of author Daryl Ducharme (Developer Relations Engineer, Google OSPO), summary bullets on 5 curated reads ($8.8T value, $1B+ spend, 2β5x grid ROI, 30+ lunar layers) and 8 fall conferences, plus a spotlight banner: "FEATURED TALK // MCP DEV SUMMIT TORONTO (OCT 6, 2026): Tag-Team Transmission: Navigating A2A and MCP for Optimum Orchestration."
ALT Slide 02/04: "OSS ECONOMICS & INFRASTRUCTURE ROI: Where the Money Goes vs. Where the Value Lives." Three metric cards: (1) READ 01 // LAURIE VOSS (SELDO.COM): "$1B+ Spend vs. $0 to Maintainers β Nobody pays for open source. We can force them to." Enterprises spend >$1B/yr on supply-chain mirrors and security scanners; Voss proposes commercial package registries pay automatic dependency-tree royalties. (2) READ 02 // ACM TECHNOLOGY POLICY COUNCIL: "$8.8 Trillion Global Demand Value β AI Is Reshaping OSS & Straining Sustainability." Funding must sustain human governance and consensus-building that AI cannot replace. (3) READ 03 // LF ENERGY FRAMEWORK: "2x β 5x Greater Net Grid Value β Proving Open Source ROI for Regulated Utilities."
ALT Slide 03/04: "AI POST-MORTEMS, LUNAR DATA & EVENTS: Hardened Supply Chains & Fall 2026 Community Radar." Top cards: (1) READ 04 // TIME (Y. BENGIO): "AI Security Post-Mortems" β treating autonomous agent breaches (Hugging Face & repo social-engineering) as engineering post-mortems to harden open supply chains. (2) READ 05 // NASA & IBM RESEARCH: "30+ Lunar Data Layers" β open-source Lunar Foundation Model and harmonized ML-ready dataset unifying 30+ instrument layers. Bottom terminal ("fall_2026_conferences.sh β 8 Upcoming Community Events"): Oct 05β06 MCP Dev Summit Toronto (Daryl Ducharme: A2A + MCP Oct 6), Oct 07β09 OSS Europe (Prague), Oct 11β14 Community Over Code (Glasgow), Oct 19β20 All Things Open (Raleigh), Oct 28β29 GitHub Universe (SF), Nov 04β05 OSFF NYC, Nov 09β12 KubeCon NA (Salt Lake City), Nov 13β14 SFSCON (Bolzano).
ALT Slide 04/04: "COMMUNITY & ECOSYSTEM // @GOOGLEOSS: Built With the Global Open Source Community." Box 1 ("FEATURED AUTHORS, FOUNDATIONS & CONFERENCES") lists X handles: Laurie Voss (@seldo), ACM (@TheOfficialACM), @linuxfoundation, @LFEnergy, @TheASF, @CloudNativeFdn, @NASA, @IBMResearch (Lunar Foundation Model), @AllThingsOpen, @sfscon, and MCP Dev Summit Toronto. Box 2 ("FALL 2026 COMMUNITY CONFERENCES & ROADMAP") lists Oct 5β9 (MCP Dev Summit Toronto & OSS EU), Oct 11β20 (Community Over Code & All Things Open), Oct 28βNov 5 (GitHub Universe & OSFF NYC), and Nov 9β14 (KubeCon NA & SFSCON). CTA banner: "Read All 5 Deep Dives & 8 Fall Event Links β First reply below: https://goo.gle/twios-17."
ALT Slide 01/04 of a dark-themed Google Open Source technical carousel titled "UPSTREAM ENGINEERING // POSTGRESQL 20: Shipping PostgreSQL 20: Inside Our 2026 Upstream Core & Extension Fixes." Subtitle: "From queryable logical replication conflict tables to single-check sequential scans and superuser-free pg_dump on Large Objects." Features a group photograph of attendees at Postgres Bangalore (PGBLR) Meetup 10 alongside the Google Cloud PostgreSQL engineering team, credited to Dilip Kumar (PostgreSQL Significant Contributor) with Nitin Motiani, Robert Pang, Aniket Jha, and Sunaina Punyani. Footer: opensource.googleblog.com β’ goo.gle/postgresql-2026-highlights.
ALT Slide 02/04 titled "LOGICAL REPLICATION & ACCESS CONTROL: Queryable Conflict Logs & Superuser-Free Large Objects." Displays two dark terminal windows with syntax-highlighted SQL. Terminal 1 ("psql β Logical Replication (PostgreSQL 20 Roadmap)") shows: CREATE SUBSCRIPTION prod_active_sub CONNECTION 'host=primary.db dbname=prod' PUBLICATION core_tables_pub WITH (conflict_log_destination = 'table'); followed by SELECT relid, conflict_type, remote_xid FROM pg_conflict.pg_conflict_log_'%sublid%';. Terminal 2 ("upstream_patches.sql β Least-Privilege & Concurrency") shows: GRANT pg_read_all_data TO backup_role; (enabling superuser-free pg_dump on Large Objects) and REINDEX TABLE CONCURRENTLY orders_with_deferrable_pk; (preserving DEFERRABLE constraint semantics across rebuilds via INDEX_CREATE_DEFERRABLE).
ALT Slide 03/04 titled "SCAN OPTIMIZATION & ECOSYSTEM FIXES: Core Scan Optimization & Ecosystem Memory Safety." Top callout banner ("CORE ENGINE OPTIMIZATION (TABLE_SCAN_NEXT)") reads: "CheckXidAlive: N Tuple Checks -> 1 Check/Scan β Eliminates redundant per-tuple transaction liveness checks in table_scan_next() by verifying CheckXidAlive once per sequential scan." Below is a 2x2 technical fix matrix: (1) STANDBY PROMOTION: pg_promote() Timeout Fix (fixed premature standby promotion timeouts under heavy load); (2) DSM HASH CLEANUP: dshash Detach Segfault (prevented segmentation faults when processes exit after FATAL); (3) PLPGSQL_CHECK & PGTT: PG14 LWLock & UAF Fixes (added shmem_request_hook LWLock registration & deep-copied plans); and (4) PGFINCORE PR #12 & #13: Buffer & Pointer Safety (fixed off-by-one buffer check and dangling pointer dereference).
ALT Slide 04/04 titled "COMMUNITY & ECOSYSTEM // @GOOGLEOSS: Built Upstream With the PostgreSQL Community." Box 1 ("UPSTREAM PROJECTS & MAINTAINERS") credits Core Engine: PostgreSQL Global Dev Group (@postgresql), plpgsql_check: Pavel Stehule (@pavel_stehule β okbob/plpgsql_check), pgfincore: CΓ©dric Villemain (klando/pgfincore β PR #12 & #13), and pgtt: Gilles Darold (darold/pgtt β Global Temp Tables). Box 2 ("UPSTREAM ROADMAP & COMMUNITY DISCUSSIONS (PGSQL-HACKERS)") lists Conflict Resolution (auto-resolving via PG 20 conflict tables), Active-Active Replication (multi-master conflict logging foundation), Extension Hardening (plpgsql_check, pgfincore & pgtt patches), and Get Involved (test patches & share feedback on pgsql-hackers). Call-to-action banner: "Full Commit Walkthrough & Extension Patch Links β β First reply below: goo.gle/postgresql-2026-highlights."
