PostgreSQL Technical Articles

Ken Zhang

Migrate multilingual full-text search from SQL Server to PostgreSQL

This AWS blog post by Ken Zhang addresses subtle result discrepancies when migrating multilingual full-text search (FTS) from SQL Server to Aurora PostgreSQL or Amazon RDS for Pos…

Read the Blog

Carlota Soto

Open-weight models are fast on Neon AI Gateway. Here's why

Open-weight AI models can be fast in theory, but actual end-user performance depends heavily on the serving infrastructure. Neon AI Gateway routes requests to Databricks Foundatio…

Read the Blog

enterprisedb.com

180x Faster Recovery: How EDB Postgres® AI Rewrote RPO/RTO Math with WarehousePG Disaster Recovery

A banking customer using logical backups faced critical issues: full backups took nearly two days, ran almost continuously, and restoring to a disaster recovery cluster required e…

Read the Blog

PostgreSQL Hackers Email Discussion Highlights

walsummarizer can get stuck when switching timelines

The discussion addresses a flaky test related to the `walsummarizer` getting stuck when switching timelines. Alexander Lakhin identified that the test failure was caused by the bg…

Read Discussion

Fix CPU cost of right-semi and right-anti hash joins

The thread discusses fixing the CPU cost estimation for RIGHT_SEMI and RIGHT_ANTI hash joins in PostgreSQL's planner. The original bug: `hashjointuples` was computed using `path->…

Read Discussion

Allow a prosupport function to be attached to an aggregate

The thread discusses adding support for attaching a `prosupport` function to an aggregate in PostgreSQL. Andrei Lepikhov assembled a two-patch series: one documenting `SupportRequ…

Read Discussion

Crash issue in PG18.5 regression

Jeff Davis committed a fix for a bug in PostgreSQL 18 related to a crash issue found in regression testing. The bug, identified by Andres Freund as a real defect despite no known…

Read Discussion

Logical replication row filter loses unchanged toasted columns

The discussion addresses a bug where logical replication row filters silently lose data when a UPDATE changes the replica identity key but leaves a TOASTed non-identity column unc…

Read Discussion

aio: Don't silently drop wait_event_info

The discussion addresses a bug where `wait_event_info` passed by callers is silently dropped in PostgreSQL's AIO subsystem. Nazir Bilal Yavuz proposed storing `wait_event_info` in…

Read Discussion

Industry News

techcrunch.com

Grok Experiences Widespread Gibberish Response Failures for Users

xAI's Grok AI assistant began sending incoherent, gibberish responses to users, with affected users reporting they were using Grok Lite when the issues emerged. The problems were…

techcrunch.com

Meta Launches Pocket App in the US, Enabling AI-Powered Game Creation and Sharing

Meta is expanding its experimental AI-powered app Pocket to users across the United States, after an initial quiet test run in Brazil. Pocket allows users to create and share inte…

techcrunch.com

Study Finds a Third of Web Pages Published Since ChatGPT's Launch Show AI Authorship Signs

A new study has found that approximately one-third of web pages published since the launch of ChatGPT show signs of AI authorship, indicating that AI models such as ChatGPT are no…

Social Media Updates

Discover how CYPEX can support your organization's PostgreSQL modernization journey.

CYPEX offers a PostgreSQL Application Platform built for organizations looking to modernize legacy applications, streamline business workflows, or develop new enterprise applicati…

Your AI is smart enough.

Databricks is hosting an event on September 23 focused on Genie Ontology, a solution designed to give AI systems deeper business context. Attendees will learn how to build a conte…

What does it take to run data behind products used by one billion people every week?

OpenAI uses Databricks as its governed, multicloud data foundation spanning Azure and AWS. The platform supports analytics, marketing, finance, trust and safety, and security oper…

PGNexus Daily News

PostgreSQL Technical Articles

PostgreSQL Hackers Email Discussion Highlights

Industry News

Social Media Updates