PGNexus Daily News

PostgreSQL Technical Articles

Scale pgvector with binary quantization on Amazon Aurora PostgreSQL

Steve Dille

Scale pgvector with binary quantization on Amazon Aurora PostgreSQL

HNSW with binary quantization (HNSW+BQ) in pgvector offers a practical approach for scaling vector search to hundreds of millions or billions of embeddings on Amazon Aurora Postgr…

Read the Blog
Query Neon backend logs

Andre Landgraf

Query Neon backend logs

Neon has expanded its backend observability tooling by introducing a way to query backend logs outside the Console. The new `neon logs` command reads logs emitted by Neon Function…

Read the Blog
Highly Available PostgreSQL on Kubernetes in 10 Minutes

Hans-Jürgen Schönig

Highly Available PostgreSQL on Kubernetes in 10 Minutes

This tutorial demonstrates deploying a highly available PostgreSQL cluster on Kubernetes using the CYBERTEC PG Operator (CPO) with a minimal 14-line YAML file. Running on minikube…

Read the Blog
Failover slot synchronization in PostgreSQL

Ajin Cherian

Failover slot synchronization in PostgreSQL

PostgreSQL 17 introduces failover slot synchronization, a feature that keeps logical replication slots maintained on standby servers. Before this, a failover in a logical replicat…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

Support EXCEPT for TABLES IN SCHEMA publications

The thread discusses patch v27/v28 adding EXCEPT clause support for TABLES IN SCHEMA publications in PostgreSQL. Peter Smith provides detailed review comments on v27-0001, flaggin…

Read Discussion
Fix a relcache reference leak in reorderbuffer.c

Chao Li reported a relcache reference leak in `reorderbuffer.c`, specifically in the `REORDER_BUFFER_CHANGE_TRUNCATE` branch of `ReorderBufferProcessTXN()`. When `RelationIsLogica…

Read Discussion
basebackup: do not verify checksums on pages written before enabling checksums

The discussion covers a patch to skip checksum verification during base backup for pages written before checksum enabling was initiated. Daniel Gustafsson squashed earlier contrib…

Read Discussion
pg_control_checkpoint(): add "data_checksum_version" (Pg19)?

Daniel Gustafsson submitted a rebased patchset adding `data_checksum_version` to `pg_control_checkpoint()`. Bertrand Drouvot reviewed it and raised two test coverage concerns: the…

Read Discussion
datachecksums: handle invalid and dropped databases during enable

Alexander Lakhin reported that a recently added test in `test_checksums/001_basic.pl` fails intermittently on slow-storage buildfarm animals (e.g., turaco on Raspberry Pi). The fa…

Read Discussion
Residual cleanups for tied objects in PL/Perl

The discussion covers residual cleanup work in PL/Perl related to tied objects. Tom Lane proposed a patch making extension modules use `hek2cstr` for hash entry key conversion, an…

Read Discussion

Click here for the full Hacker discussion highlights

 

Industry News

Etched's Valuation Doubles to $21B After Jane Street-Led Funding Round

techcrunch.com

Etched's Valuation Doubles to $21B After Jane Street-Led Funding Round

AI chip startup Etched has seen its valuation double to $21 billion in just one month, following a major new funding round led by Jane Street. The financial firm had previously in…
OpenAI Institutes New Safeguards Following Hugging Face Security Breach

techcrunch.com

OpenAI Institutes New Safeguards Following Hugging Face Security Breach

OpenAI has announced new security safeguards in response to a breach at Hugging Face. The updated measures include more detailed monitoring of AI models throughout the development…
OpenAI Launches Teen-Specific ChatGPT with Safety Controls and Parental Tools

techcrunch.com

OpenAI Launches Teen-Specific ChatGPT with Safety Controls and Parental Tools

OpenAI has launched a dedicated version of ChatGPT designed for teenagers, introducing age-appropriate safety measures, parental controls, and learning-focused tools. The product,…

Social Media Updates

The Year 2038 problem is increasingly less about modern databases and more about the legacy infrastructure surrounding them.

linkedin

The Year 2038 problem is increasingly less about modern databases and more about the legacy infrastructure surrounding them.

The Year 2038 problem, which stems from 32-bit Unix timestamp overflow, is no longer primarily a concern for modern databases. PostgreSQL, for example, handles timestamps well bey…

linkedin

🏆 At the Databricks Grounded Reasoning Cup, academic teams from Stanford, UMass, Yale and other universities tackled a previously unseen corpus and set of tasks to answer one of the hardest questions in AI evaluation: how well do performance improvements on a benchmark generalize to similar, real-world tasks?

At the Databricks Grounded Reasoning Cup, academic teams from Stanford, UMass, Yale, and other universities faced an unseen corpus and task set to address a core AI evaluation que…

linkedin

Getting started with Databricks Apps can be as simple as giving your coding agent the right prompt.

Starting with Databricks Apps can be straightforward using the right prompt for your coding agent. DevHub prompts can check your environment, handle setup, scaffold an app, and de…

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