PGNexus Daily News

PostgreSQL Technical Articles

Custom domains for Neon Functions

Carlota Soto

Custom domains for Neon Functions

Neon Functions, currently in beta, previously exposed endpoints only via auto-generated invocation URLs. Neon has added custom domain support, allowing users to map their own doma…

Read the Blog
Your Neon Functions can now run on a schedule

Mike Jerome

Your Neon Functions can now run on a schedule

Neon Functions now support scheduled execution, removing the need for external schedulers to trigger backend jobs. Previously, functions could only be invoked via HTTP requests, w…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

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

Bharath Rupireddy submitted v19 patches (including backbranch versions) for a fix that releases replication slots on error in SQL-callable slot functions. The v19 update is a mino…

Read Discussion
Support for 8-byte TOAST values, round two

The thread follows up on the recently applied patch set adding 8-byte TOAST value support. John Naylor noted that doc/src/sgml/limits.sgml still needs updating. Bharath Rupireddy…

Read Discussion
pg_walinspect: fix LSN validation messages and empty range handling

Chao Li identified two issues in pg_walinspect: (1) commit 5c1b6628075a relaxed LSN validation checks from `>=` to `>` but left error messages saying "must be less than current LS…

Read Discussion
[PATCH] Explain what the default output_plugin_libraries do

This thread discusses a documentation patch explaining what the default `output_plugin_libraries` configuration does in PostgreSQL logical replication. Hayato Kuroda submitted a r…

Read Discussion
Adding a stored generated column without long-lived locks

Alberto Piai used an LLM-based tool to analyze his patch for adding stored generated columns without long-lived locks, and discovered a flaw in his use of `IS NOT DISTINCT FROM`.…

Read Discussion
Why clearing the VM doesn't require registering vm buffer in wal record

The discussion focuses on a data corruption scenario involving the visibility map (VM) and `PD_ALL_VISIBLE` flag during WAL replay on standbys. When `CREATE DATABASE STRATEGY WAL_…

Read Discussion

Click here for the full Hacker discussion highlights

 

Industry News

Meta's Muse AI Agent Outpaces ChatGPT's Early Mobile Launch in Downloads

techcrunch.com

Meta's Muse AI Agent Outpaces ChatGPT's Early Mobile Launch in Downloads

Meta's new AI agent Muse has accumulated more downloads and daily active users in the U.S. and Canada than ChatGPT did during the same post-launch period after its mobile debut, a…

OpenAI Forms Math Advisory Group as AI Resolves Over 100 Open Problems

techcrunch.com

OpenAI Forms Math Advisory Group as AI Resolves Over 100 Open Problems

OpenAI has established a math advisory group following its AI's achievement of resolving more than 100 previously open mathematical problems. However, the advisory group will not…

Kairos Power Secures Up to $100M from Samsung Group to Build Nuclear Reactor for Google

techcrunch.com

Kairos Power Secures Up to $100M from Samsung Group to Build Nuclear Reactor for Google

Nuclear energy startup Kairos Power has secured up to $100 million from Samsung C&T to help construct its first 50-megawatt nuclear power plant, which is intended to supply energy…

Social Media Updates

More memory?

linkedin

More memory?

The CYBERTEC PG Operator simplifies common PostgreSQL cluster management tasks on Kubernetes. Operations such as increasing memory, adding replicas, or upgrading to a new minor ve…

Give AI the right business context, and it can deliver more trusted answers and help teams take action with confidence.

linkedin

Give AI the right business context, and it can deliver more trusted answers and help teams take action with confidence.

An upcoming webinar on Wednesday, Sept. 23 will cover how to give AI the right business context to deliver more reliable answers and enable confident decision-making. Topics inclu…

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