Search fresh public links, source activity, and ready-to-use post angles for Postgres.
Fresh curated links around postgres are collected here so marketers can spot useful updates and turn timely ideas into posts faster.
Recent items include:
Recent curated links from global sources. Generate one free draft from any story, then use SocialBu to schedule and refine your content calendar.
PGW: A PGBACKREST INTERLUDE:(Andreas Scherbaum, Jimmy Angelakos)Andreas Scherbaum and Jimmy Angelakos presented a quantitative analysis of the PostgreSQL CommitFest process using d...
Originally appeared on The Rails Tech Debt Blog.Heroku sent us an email about the database behind ips.fastruby.io, a small app we run for sharing benchmark-ips results. That databa...
PostgreSQL 19 adds SQL/PGQ graph queries, a critical logical replication flaw is patched, and AWS DMS now uses AI agents for SQL Server migrations. Get the full breakdown. The post...
SQL Server stored procedures can return multiple result sets from one call, but PostgreSQL cannot. This post presents two PostgreSQL-native alternatives to refcursors, session-scop...
PostgreSQL 19 adds native SQL/PGQ graph support, while a critical logical replication flaw (CVE-2026-6471) is patched in all versions. Learn what this means for your database. The...
PostgreSQL 19 removes SQL/PGQ, but REPACK CONCURRENTLY, Spinnaker's migration tools, Vacuum monitoring, and AlloyDB Omni orchestrator bring new capabilities for DBAs. The post Post...
SQL/PGQ gets bounced over unresolved bugs as concurrent REPACK promises fewer midnight calls for DBAs
PostgreSQL has released updates to address a security flaw that allows an account with the REPLICATION attribute to run arbitrary code as the operating-system user running the data...
AWS Aurora PostgreSQL now queries Iceberg and Parquet data in S3 without ETL, using DuckDB and familiar SQL. See versions, setup, limits, and costs. The post AWS Aurora PostgreSQL...
Привет, Хабр. Я хочу рассказать историю, которую вы уже, наверняка, где-то слышали. Только с другой стороны.Пару месяцев назад я сидела на созвоне с техдиром стартапа, который дела...
You wanna learn PostgreSQL, and you wanna use a sample database with big real-world data, the same kinds of issues that pop up with real-life data distribution skew, and fun query...
A critical PostgreSQL vulnerability dubbed PostGREShell could allow low-privileged replication accounts to execute attacker-controlled code, escalate to database superuser, and est...
Database migrations can pass every check in development and still take production down, and the classic example is adding a NOT NULL column with no default to a table that already...
Stop relying on slow LIKE queries. Learn how to implement Trigrams and Full Text Search in PostgreSQL for lightning-fast, pro-level results. The post Mastering Advanced Search Tech...
Stop overcomplicating your stack. Learn how to build resilient, durable workflows using Postgres as your orchestrator to eliminate external dependencies. The post Mastering Durable...
Python PostgreSQL with asyncpg: Async Database Operations asyncpg is the fastest PostgreSQL driver for Python — pure asyncio, no thread overhead, and up to 3× faster than psyc...
Baked-in SQL syntax arrives through multi-vendor collaboration, although indexing still needs to catch up
https://thomasleecopeland.com/2026/08/17/from-sphinx-to-postgres-fts.html
PostgreSQL 19 is set to ship with native SQL/PGQ support for property graph queries, thanks to a multi-vendor collaboration. Here’s what it means for you and when to expect it. The...
There is a whole class of questions SQL cannot ask. Not “tickets created this week”; SQL is good at that. “Tickets where the customer…Continue reading on Data Arkaive »
Когда говорят о DuckDB, обычно вспоминают аналитику: локальные запросы к Parquet, быстрые агрегации, ноутбуки. Но у него есть свойство, к аналитике отношения не имеющее: он умеет с...
This story started when we found several segfaults in Apache AGE. Segfaults in a young extension are not exactly shocking, but they raised a fair question: if stability is still a...
Завершаем цикл статей с обзором изменений 19-й версии. Предыдущие статьи были посвящены первым четырем коммитфестам: 2025-07, 2025-09, 2025-11, 2026-01.А сегодня начнем обзор марто...
Originally appeared on Weelkly Article – Linking Ruby knowledge from the most remote places in the world..August 6, 2026 Most Rails applications that implement multi-tenancy eventu...
Use SocialBu to discover ideas, generate post drafts, and schedule them across your social channels.