Postgresso 7–8 (92–93)
PGW: A PGBACKREST INTERLUDE:(Andreas Scherbaum, Jimmy Angelakos)Andreas Scherbaum and Jimmy Angelakos presented a quantitative analysis of the PostgreSQL CommitFest process using d...
Search fresh public links, source activity, and ready-to-use post angles for Postgresql.
Fresh curated links around postgresql 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...
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...
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...
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...
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 news roundup: AWS DuckDB in Aurora, Babelfish FTS gaps, DBtune automation, Nebius managed clusters, Tom Lane architecture, Splunk CVE. The post PostgreSQL Ecosystem Expa...
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...
SQL/PGQ gets bounced over unresolved bugs as concurrent REPACK promises fewer midnight calls for DBAs
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...
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...
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...
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...
Когда говорят о DuckDB, обычно вспоминают аналитику: локальные запросы к Parquet, быстрые агрегации, ноутбуки. Но у него есть свойство, к аналитике отношения не имеющее: он умеет с...
Привет, Хабр. Я хочу рассказать историю, которую вы уже, наверняка, где-то слышали. Только с другой стороны.Пару месяцев назад я сидела на созвоне с техдиром стартапа, который дела...
Baked-in SQL syntax arrives through multi-vendor collaboration, although indexing still needs to catch up
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...
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 »
https://thomasleecopeland.com/2026/08/17/from-sphinx-to-postgres-fts.html
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...
How CORTO scaled Amazon Aurora PostgreSQL with pgvector to 7.6 billion vectors and 2.5 billion documents in production, delivering sub-second legal search for 10,000+ law firms at...
A critical PostgreSQL vulnerability dubbed PostGREShell could allow low-privileged replication accounts to execute attacker-controlled code, escalate to database superuser, and est...
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...
PostgreSQL является самой распространённой СУБД согласно исследованию StackOverflow. Но самостоятельный хостинг PostgreSQL сопряжён с риском потери данных и неоптимальной настройки...
Use SocialBu to discover ideas, generate post drafts, and schedule them across your social channels.