Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 2 Stunden 46 Minuten

Bryan Green: Working the PgUS Booth at Texas Linux Fest 2026

17. November 2026 - 5:43
My first time volunteering at a conference: the PgUS booth at Texas Linux Fest 2026. Mostly it was stickers, hats, and asking people how they use Postgres. Then a couple of students from Texas A&M came by.

Dave Stokes: Getting Started With Ollama With DBeaver Community Edition

17. November 2026 - 2:30

 Ollama is popular because it makes running large language models (LLMs) locally simple, private, and inexpensive. DBeaver 26.2.5, also free & open-source, recently added support for Ollama. And both pair well with PostgreSQL.

Why Ollama Is Popular?
  1. Runs AI Locally — Execute models such as Llama, Qwen, Gemma, and DeepSeek on your own computer without relying on cloud services.

Dinesh Kumar: pgSherpa: a PostgreSQL companion for your Mac, now on the Mac App Store

17. November 2026 - 0:00
pgSherpa is a free PostgreSQL companion for macOS, now on the Mac App Store: health, security, cloud events on AWS, DigitalOcean and Supabase, read-only SQL.

David E. Wheeler: Build, Test and Release Extensions with the New PGXN GitHub Actions

16. November 2026 - 21:14

I’ve made three new GitHub actions in the past few months to replace the venerable Docker-based pgxn/pgxn-tools, which has become bloated and requires more work to maintain than I’d like. The new actions require much less maintenance, support all GitHub runner OSes and architectures, and run more quickly. What they do:

Chris van Eijk: invalid input syntax for type json in PostgreSQL, measured

15. November 2026 - 23:30
What raises 'invalid input syntax for type json' (22P02), measured on PostgreSQL 16 to 18: JS arrays, Python lists, NUL escapes, bad rows and a safe ALTER.

Dinesh Kumar: How to Reduce PostgreSQL Memory Usage and Cut Your Cloud Bill in Half

14. November 2026 - 19:45
How to reduce PostgreSQL memory usage and your cloud bill: one pooler setting took a customer from 93% memory to 50%, and from $630 to $320 a month.

Jianghua yang: Pricing plans in PostgreSQL's currency: pg_orca's PG-aligned cost model

14. November 2026 - 1:00
How pg_orca replaced ORCA's Greenplum-calibrated cost model with a port of PostgreSQL's costsize.c: where it plugs in, how it bridges ORCA's total-only costs and rebinds to PostgreSQL's startup costs and loop counts, and how a regression harness keeps both planners within 2%.

Jeremy Schneider: Postgres 18.7 Debian and Redhat Packagers Protect You

13. November 2026 - 17:28

Just a short & quick follow-up to [yesterdays blog] before I run out the door.

I hadn’t been paying attention, and yesterday’s postgres release had a few surprises for me. I’m catching up now.

Andrew Dunstan: Announcing Release 22 of the PostgreSQL Buildfarm client

13. November 2026 - 16:46
New features
  • PGXSExtension module — a single config-driven module for testing
    out-of-tree PGXS extensions, keyed by a pgxs_extensions hash in the
    config (one entry per extension). New test extensions no longer need
    their own bespoke .pm file. The existing BlackholeFDW, FileTextArrayFDW
    and RedisFDW modules remain for now so existing configs keep working.
  • New branches-to-build tags UNRELEASED and HEAD_PLUS_UNRELEASED,
    covering branches between the time the tree is forked and a release is

Ruohang Feng: PostgreSQL Just Patched 52 CVEs in a Single Minor Release

13. November 2026 - 1:00
PostgreSQL’s November minor releases patch 52 CVEs and 140+ bugs across all supported branches and retire PostgreSQL 14. Notes on what continuous AI code auditing is doing to 30-year-old C codebases, the post-upgrade steps you can’t skip, same-day Pigsty 4.6 packages, and Simplified Chinese localization landing in PG 14–19.

Greg Nancarrow: Build resilient AI workflows with DBOS and Fujitsu Enterprise Postgres

13. November 2026 - 0:45

Discover how DBOS and Fujitsu Enterprise Postgres combine durable execution, automatic recovery, and robust data encryption to power resilient, secure AI agents and applications, demonstrated through a practical Python deployment.

Jeremy Schneider: Postgres 18.7 minor breaks ABI compatibility again

12. November 2026 - 20:12

Postgres API and ABI stability has been a topic of discussion for a long time. To understand why this matters so much, start with Dave Stokes recent blog post [Is PostgreSQL Really Winning Part 2: The Evidence Beyond the Rankings]. It’s fundamentally about “a slow core with a fast edge is a pretty good design” and how the Postgres extension API enables an amazing ecosystem around Postgres.

Devrim GÜNDÜZ: PostgreSQL November 2026 minor releases: update the server and extensions together

12. November 2026 - 13:58



PostgreSQL 18.7, 17.12, 16.16, 15.20 and 14.25 are out today. If you use the PGDG RPM repositories (yum.postgresql.org or zypp.postgresql.org), please update PostgreSQL and all of your extensions in the same transaction this time. Do not update the server today and the extensions next month, and do not hold one back while the other moves.

Lukas Fittl: Postgres 18.7 Security Release: The Impact of CVE-2026-6460 & other memory corruption issues

12. November 2026 - 13:00

In today’s E123 of “5mins of Postgres” we’re talking about the Postgres 18.7, 17.12, 16.16, 15.20 and 14.25 minor releases that were released today, which fix 52 security vulnerabilities and other bugs in Postgres. In this episode we focus on the security impact of the release, but the release also contains other important fixes.

Floor Drees:

12. November 2026 - 1:00
We had a chance to talk to Mohsin Ejaz, Principal Customer Solutions Engineer at DBtune, an agentic AI database optimization service.

uzair aslam: Vercel Cron Jobs in Production: Secure, Retry-Safe Jobs with Next.js

11. November 2026 - 23:51

Build Vercel Cron Jobs in Next.js with CRON_SECRET, PostgreSQL locks, bounded backfill, safe retries, and a practical production debugging guide.

Your daily report runs at 02:00 UTC. One morning it never reaches the app. The following day it arrives twice, and both invocations try to produce the same report. A route that processes “today” on each request skips the missing day and may repeat yesterday’s work. The fix is to record which days are due and which were completed in PostgreSQL.

uzair aslam: PostgreSQL Vector Search with pgvector: Hybrid Search in Next.js

11. November 2026 - 23:51

Build PostgreSQL vector search with pgvector and Next.js. Compare keyword and hybrid ranking, enforce tenant access, and reproduce filtered HNSW recall.

A support engineer searches for AUTH-4017. The most useful result is the ticket with that exact error code. Another engineer types “sign-in works until I close the browser” and wants the ticket about a session cookie disappearing on restart. These queries need different kinds of evidence. A useful search feature can combine both without sending the entire support archive to a model.

Christophe Pettus: Stop Using AI to Report PostgreSQL Bugs

11. November 2026 - 18:37
Lately, the PostgreSQL’s bug-report mailing list has been receiving a large number of AI-generated bug reports. Often, these come in flurries of 10-15 bugs, each from the same email address. These bug reports are of, shall we say, highly variable quality. Just looking through a few of the recent … (I consult on PostgreSQL through PGX Inc..)

Umair Shahid: Life After PostgreSQL 14

11. November 2026 - 14:50

PostgreSQL 14 receives its final minor release tomorrow, November 12, 2026. No new security or bug fixes ship for it after that. Your database keeps running, but every vulnerability found after that date stays open on your servers.

PostgreSQL 15 follows on November 11, 2027. If you run either version in production, this post covers the three decisions that matter: which version to move to, which method to use, and how to make the switchover a non-event.

Seiten