PGNexus Daily News PostgreSQL Technical Articles [image: PostgreSQL security best practices for regulated environments] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> Fujitsu PostgreSQL security best practices for regulated environments <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> PostgreSQL security in regulated environments goes beyond standard controls like authentication, encryption, and access restrictions. Compliance frameworks such as HIPAA, PCI DSS,… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.postgresql.fastware.com%...> [image: Time-Series Cardinality: Why One More Indexed Column Costs More Than a Million More Rows] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Ft...> Damaso Sanoja Time-Series Cardinality: Why One More Indexed Column Costs More Than a Million More Rows <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Ft...> Adding a single indexed column to a wide time-series table in PostgreSQL costs far more than adding a million rows. A benchmark using 100 million rows on PostgreSQL 17.10 with Tim… Read the Blog <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Ft...> PostgreSQL Hackers Email Discussion Highlights [PATCH] Release replication slot on error in SQL-callable slot functions <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20replic...> The discussion centers on a patch to release replication slots on error in SQL-callable slot functions, specifically addressing crash behavior during subtransaction aborts. Key de… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=%5BPATCH%5D%20Release%20replic...> Error handling in after-startup shmem requests <https://pgnexus.ai/hacker-discussions?subject=Error%20handling%20in%20after-...> A patch addressing error handling in after-startup shared memory requests was reviewed by Ayush Tiwari, who confirmed the tests passed when run in parallel, and subsequently commi… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Error%20handling%20in%20after-...> Randomize B-Tree page split location to avoid oscillating patterns <https://pgnexus.ai/hacker-discussions?subject=Randomize%20B-Tree%20page%20sp...> The discussion focuses on randomizing B-Tree page split location selection to avoid oscillating patterns. The thread examines a reservoir-sampling-style algorithm: instead of coll… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=Randomize%20B-Tree%20page%20sp...> pg_stat_get_autovacuum_scores ignores the main table's reloptions for TOAST tables <https://pgnexus.ai/hacker-discussions?subject=pg_stat_get_autovacuum_scores%20ignores%20the%20main%20table's%20reloptions%20for%20TOAST%20tables> Masahiko Sawada reported that `pg_stat_get_autovacuum_scores()` computes incorrect scores for TOAST tables when the main table has `autovacuum_*` reloptions set but the TOAST tabl… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=pg_stat_get_autovacuum_scores%20ignores%20the%20main%20table's%20reloptions%20for%20TOAST%20tables> REPACK (ANALYZE) within transaction block segfaults <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(ANALYZE)%20within%20...> The discussion addresses a segfault when `REPACK (ANALYZE)` is executed inside a transaction block. Fujii Masao initially proposed rejecting only non-top-level executions (e.g., i… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=REPACK%20(ANALYZE)%20within%20...> timeout value overflow in wait for lsn <https://pgnexus.ai/hacker-discussions?subject=timeout%20value%20overflow%20i...> The discussion addresses two bugs in the `WAIT FOR LSN` timeout handling: an integer overflow when timeout values exceed INT_MAX across multiple sleep iterations, and incorrect be… Read Discussion <https://pgnexus.ai/hacker-discussions?subject=timeout%20value%20overflow%20i...> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-28-postgresql-daily-news-252.m...> Industry News [image: Open-Weight AI Companies Emerge as Silicon Valley's Hottest Acquisition Targets] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> techcrunch.com Open-Weight AI Companies Emerge as Silicon Valley's Hottest Acquisition Targets <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> According to TechCrunch, open-weight AI companies have become among the most sought-after acquisition targets in Silicon Valley. Significant capital is flowing into businesses tha… [image: a16z Launches $1.1B 'Machine Age' Fund to Back AI Physical Infrastructure] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> techcrunch.com a16z Launches $1.1B 'Machine Age' Fund to Back AI Physical Infrastructure <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> Andreessen Horowitz (a16z), the prominent venture capital firm long associated with software investing, has created a $1.1 billion fund called the "Machine Age" fund. The fund is… [image: Anthropic Wins First Court Ruling Against Pentagon's Supply-Chain Risk Designation] <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> techcrunch.com Anthropic Wins First Court Ruling Against Pentagon's Supply-Chain Risk Designation <https://pgnexus.ai/tech-news?url=https%3A%2F%2Ftechcrunch.com%2F2026%2F08%2F...> A federal judge has ruled that the Trump administration illegally labeled Anthropic a supply-chain risk, handing the AI company its first legal victory in an ongoing dispute with… Social Media Updates [image: pgwatch v6.0.0-beta can now scrape a Prometheus exporter directly, as a first-class source, side by side with your regular PostgreSQL sources.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin pgwatch v6.0.0-beta can now scrape a Prometheus exporter directly, as a first-class source, side by side with your regular PostgreSQL sources. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> pgwatch v6.0.0-beta introduces the ability to scrape a Prometheus exporter directly as a first-class monitoring source, placing it on equal footing with regular PostgreSQL sources… linkedin Your data. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> Data AI World Tour 2026 is an event series focused on how organizations can ground AI in enterprise data and business context to achieve real outcomes. Attendees can expect the la… [image: Our partners are bringing a new wave of production-ready, industry-specific solutions to Lakebase.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin Our partners are bringing a new wave of production-ready, industry-specific solutions to Lakebase. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> A range of partners have developed production-ready, industry-specific solutions built on Lakebase, covering financial services, manufacturing, energy, retail, healthcare, communi… Want to stay up to date with the PostgreSQL community and industry news? Visit PGNexus <https://pgnexus.ai> to learn more