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...
Привет, Хабр! Меня зовут Андрей, я директор департамента внутренних систем ЮMoney. Эту статью я подготовил в соавторстве с Владиславом, руководителем группы разработки и сопровожде...
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...
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...
Привет, Хабр. Я хочу рассказать историю, которую вы уже, наверняка, где-то слышали. Только с другой стороны.Пару месяцев назад я сидела на созвоне с техдиром стартапа, который дела...
After reading our top 50+ PostgreSQL interview questions with answers for beginners and intermediate level candidates, you know exactly what interviewers are looking for in an appl...
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...
Originally appeared on RubySec.An authenticated user can kill connections and certain Postgres backend processes for other databases on the same instance if the PgHero database use...
Workhorse keeps your background jobs in PostgreSQL and runs them in Ruby, TypeScript, Python, Go and Rust.
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
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 »
Use SocialBu to discover ideas, generate post drafts, and schedule them across your social channels.