PGNexus Daily News

PostgreSQL Technical Articles

Neon skills landed in the Vercel CLI

Carlota Soto

Neon skills landed in the Vercel CLI

Vercel has updated its CLI to automatically install agent skills alongside Marketplace integrations. When a developer runs the command to add Neon as an integration, the CLI now a…

Read the Blog
Continuous Aggregate Refresh, Demystified: Invalidation, Lookback, and Late-Arriving Data

Damaso Sanoja

Continuous Aggregate Refresh, Demystified: Invalidation, Lookback, and Late-Arriving Data

A TimescaleDB continuous aggregate uses an invalidation log and a scheduled refresh policy to stay current. Two offsets on the policy—start_offset (lookback window) and end_offset…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

Report index currently being vacuumed in pg_stat_progress_vacuum

The discussion concerns a patch (v3) to expose which index each parallel vacuum worker is currently processing in `pg_stat_progress_vacuum`. A key issue arose: `leader_pid` can be…

Read Discussion
Doc update proposal for the note on log_statement in the runtime config for logging page

A documentation update proposal for the `log_statement` section in the runtime configuration logging page reached consensus. Daniel Bauman's V3 patch was reviewed by Robert Treat,…

Read Discussion
pgstat: Flush some statistics within running transactions, take 2

Sami Imseih posted a rebased version of the patch for flushing PostgreSQL statistics mid-transaction. Key changes address prior review feedback: index stats are now a separate kin…

Read Discussion
CREATE OR REPLACE MATERIALIZED VIEW

The discussion centers on whether `CREATE OR REPLACE MATERIALIZED VIEW` is the right syntax for allowing users to update a materialized view's refresh query. Paul Jungwirth raised…

Read Discussion
Compression of bigger WAL records

The discussion covers Andrey Borodin's patch series (now v9) for WAL compression improvements, comprising three patches: reusing zstd contexts for both compression and decompressi…

Read Discussion
MERGE/SPLIT PARTITIONS issues/questions

The discussion focuses on the `MERGE`/`SPLIT PARTITIONS` feature slated for PostgreSQL 19, specifically the silent dropping of partition-specific properties—RLS policies, ACLs, in…

Read Discussion

Click here for the full Hacker discussion highlights

 

Social Media Updates

🚀 We're hiring: Senior Full-Stack Engineer (CYPEX) Remote (Europe) | Full-time If you're a seasoned engineer who loves PostgreSQL, modern web stacks, and shaping products end-to-end, then this one's for you.

linkedin

🚀 We're hiring: Senior Full-Stack Engineer (CYPEX) Remote (Europe) | Full-time If you're a seasoned engineer who loves PostgreSQL, modern web stacks, and shaping products end-to-end, then this one's for you.

CYPEX is hiring a Senior Full-Stack Engineer for a full-time remote position open to candidates based in Europe. The role suits experienced engineers with a strong interest in Pos…

linkedin

Bally's Corporation built Vitruvian, its enterprise Data and AI platform, on Databricks to create a faster, more scalable operating model across its digital and retail gaming business.

Bally's Corporation developed Vitruvian, its enterprise Data and AI platform, on Databricks to unify data, analytics, and machine learning across its digital and retail gaming ope…

It's time to scale AI.

linkedin

It's time to scale AI.

The Data AI World Tour 2026 is a free, one-day event series coming to multiple cities. It focuses on moving AI from experimentation into production using governed data, models, ap…

Want to stay up to date with the PostgreSQL community and industry news?
Visit PGNexus to learn more