Daily edition · PostgreSQL
TILens turns technical updates into a focused daily brief: official releases, trusted reporting, and practitioner analysis, deduplicated and organized by topic.
6 articles · 4 sources ·
Top topics: PostgreSQL · AWS · Information Retrieval
Part 2 of migrating SSIS packages to Amazon Aurora PostgreSQL tackles the complex packages. Learn how to replace SSIS control flow, Foreach Loop Containers, and Script Tasks with AWS Step Functions state machines, Map…
Migrating SQL Server Integration Services (SSIS) packages is one of the more complex parts of moving from SQL Server to Amazon Aurora PostgreSQL. In Part 1 of this two-part series, learn how to filter, categorize, and…
PGX Inc. has released version 1.0 of pgx-bm25, an extension that adds Okapi BM25 ranked full-text search to PostgreSQL as a native index access method. It supports PostgreSQL 17 and 18, and installs as bm25_native.…
pg_plan_filter version 1.0.0 has been released. This loadable module test sstatements against specific configured criteria before execution, raising an error if the criteria are violated. This allows administrators to…
PostgreSQL 18's new `num_os_semaphores` preset reports how many OS semaphores the server needs—a formula that drifted wrong for twelve years until the… (I consult on PostgreSQL through PGX Inc..)
#668 — October 7, 2026 Web Version Postgres Weekly Query Plan Rewriting in Postgres — A tour of the Postgres 18 planner's query transformations, including constant folding, inlining, subquery flattening, and join…
