PGNexus Daily News PostgreSQL Technical Articles [image: Neon skills landed in the Vercel CLI] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-skill...> Carlota Soto Neon skills landed in the Vercel CLI <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-skill...> 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 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fneon.com%2Fblog%2Fneon-skill...> [image: Continuous Aggregate Refresh, Demystified: Invalidation, Lookback, and Late-Arriving Data] <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fc...> Damaso Sanoja Continuous Aggregate Refresh, Demystified: Invalidation, Lookback, and Late-Arriving Data <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fc...> 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 <https://pgnexus.ai/tech-blogs?url=https%3A%2F%2Fwww.tigerdata.com%2Fblog%2Fc...> PostgreSQL Hackers Email Discussion Highlights Report index currently being vacuumed in pg_stat_progress_vacuum <https://pgnexus.ai/hacker-discussions?subject=Report%20index%20currently%20b...> 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 <https://pgnexus.ai/hacker-discussions?subject=Report%20index%20currently%20b...> Doc update proposal for the note on log_statement in the runtime config for logging page <https://pgnexus.ai/hacker-discussions?subject=Doc%20update%20proposal%20for%...> 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 <https://pgnexus.ai/hacker-discussions?subject=Doc%20update%20proposal%20for%...> pgstat: Flush some statistics within running transactions, take 2 <https://pgnexus.ai/hacker-discussions?subject=pgstat%3A%20Flush%20some%20sta...> 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 <https://pgnexus.ai/hacker-discussions?subject=pgstat%3A%20Flush%20some%20sta...> CREATE OR REPLACE MATERIALIZED VIEW <https://pgnexus.ai/hacker-discussions?subject=CREATE%20OR%20REPLACE%20MATERI...> 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 <https://pgnexus.ai/hacker-discussions?subject=CREATE%20OR%20REPLACE%20MATERI...> Compression of bigger WAL records <https://pgnexus.ai/hacker-discussions?subject=Compression%20of%20bigger%20WA...> 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 <https://pgnexus.ai/hacker-discussions?subject=Compression%20of%20bigger%20WA...> MERGE/SPLIT PARTITIONS issues/questions <https://pgnexus.ai/hacker-discussions?subject=MERGE%2FSPLIT%20PARTITIONS%20i...> 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 <https://pgnexus.ai/hacker-discussions?subject=MERGE%2FSPLIT%20PARTITIONS%20i...> Click here for the full Hacker discussion highlights <https://pgnexus.ai/daily-updates?file=2026-08-14-postgresql-daily-news-238.m...> Social Media Updates [image: 🚀 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.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> 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. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> 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. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> 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… [image: It's time to scale AI.] <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> linkedin It's time to scale AI. <https://pgnexus.ai/social-media?url=https%3A%2F%2Fwww.linkedin.com%2Fposts%2...> 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 <https://pgnexus.ai> to learn more