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 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...
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 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...
pgrust это СУБД или злая шутка?Майкл Мэйлис (Michael Malis), житель Сан Франциско, основатель freshpaint‑io, работал в компании Heap — человек в мире Postgres не слишком известный,...
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...
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...
Cloud database upstart wants one virtual machine core to power multiple SQL frontends
Modern applications frequently require background jobs such as cleaning expired sessions, refreshing materialized views, archiving historical data, sending notifications, or genera...
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...
The moment a feature needs to update live, a live counter, a presence indicator, a "new message" badge, an activity feed, the reflex is to reach for a websocket service. Pusher, Ab...
In the Medium blog post, "From MARS to SETOF REFCURSOR: Migrating Multi-Result Stored Procedures to PostgreSQL," we explored the fundamental architectural differences between SQL S...
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
У каждого релиза Postgres свой характер.Одни релизы строятся вокруг громкой фичи. Другие решают давнюю проблему. Третьи содержат небольшие улучшения, которые замечаешь только после...
Когда говорят о DuckDB, обычно вспоминают аналитику: локальные запросы к Parquet, быстрые агрегации, ноутбуки. Но у него есть свойство, к аналитике отношения не имеющее: он умеет с...
You have a row in Postgres. You want that same row in MongoDB — not tonight in a batch job, but the instant it changes. And next month you'll want it in Redis too, and maybe POST...
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...
https://www.deadbro.com/blog/moving-large-json-request-payloads-from-postgres-to-minio Our Postgres table grew 30x in a month (10GB → 300GB). Here’s how we fixed the storage proble...
Перед командой, выросшей на MySQL/MariaDB, встаёт вопрос перехода на PostgreSQL: лицензии, экосистема расширений, более предсказуемое поведение при конкурентных нагрузках - причин...
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...
Мы продолжаем праздновать 30-летие PostgreSQL и публикуем перевод второй фундаментальной статьи о СУБД. Перевод первого манифеста можно прочесть в этом посте. Читать далее
При создании отказоустойчивых систем стремятся гарантировать отсутствие потерь транзакций при восстановлении из бэкапов или при переключении на реплику (резервный кластер баз данны...
When an enterprise decides to migrate from SQL Server to PostgreSQL, the first conversation is almost always about data movement. How many terabytes need to transfer? Which replica...
Use SocialBu to discover ideas, generate post drafts, and schedule them across your social channels.