PGNexus Daily News

PostgreSQL Technical Articles

PostgreSQL security best practices for regulated environments

Fujitsu

PostgreSQL security best practices for regulated environments

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
Time-Series Cardinality: Why One More Indexed Column Costs More Than a Million More Rows

Damaso Sanoja

Time-Series Cardinality: Why One More Indexed Column Costs More Than a Million More Rows

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

PostgreSQL Hackers Email Discussion Highlights

[PATCH] Release replication slot on error in SQL-callable slot functions

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
Error handling in after-startup shmem requests

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
Randomize B-Tree page split location to avoid oscillating patterns

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
pg_stat_get_autovacuum_scores ignores the main table's reloptions for TOAST tables

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
REPACK (ANALYZE) within transaction block segfaults

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
timeout value overflow in wait for lsn

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

Click here for the full Hacker discussion highlights

 

Industry News

Open-Weight AI Companies Emerge as Silicon Valley's Hottest Acquisition Targets

techcrunch.com

Open-Weight AI Companies Emerge as Silicon Valley's Hottest Acquisition Targets

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…

a16z Launches $1.1B 'Machine Age' Fund to Back AI Physical Infrastructure

techcrunch.com

a16z Launches $1.1B 'Machine Age' Fund to Back AI Physical Infrastructure

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…

Anthropic Wins First Court Ruling Against Pentagon's Supply-Chain Risk Designation

techcrunch.com

Anthropic Wins First Court Ruling Against Pentagon's Supply-Chain Risk Designation

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

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.

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.

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.

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…

Our partners are bringing a new wave of production-ready, industry-specific solutions to Lakebase.

linkedin

Our partners are bringing a new wave of production-ready, industry-specific solutions to Lakebase.

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 to learn more