Social Media Ideas for Postgresql Performance

Latest updates for Postgresql Performance

Fresh curated links around postgresql performance are collected here so marketers can spot useful updates and turn timely ideas into posts faster.

Post angles to try

Share the most useful takeaway for your audience.

Turn one article into a quick practical checklist.

Ask your audience how this shift affects their work.

Turn angles into scheduled posts

Fresh articles and ideas

Recent curated links from global sources. Generate one free draft from any story, then use SocialBu to schedule and refine your content calendar.

habr.com /1 week ago

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...

Read source

dev.to /2 days ago

Apache AGE under load: how PostgreSQL graphs behave under stress

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...

Read source

habr.com /3 weeks ago

Асинхронный I/O в PostgreSQL или история выходного дня

Про асинхронный ввод-вывод в PostgreSQL за последний год написали многие:Механизм появился в 18-й версии, в 19-й его докрутили и в релиз-нотах он числится среди главных улучшений п...

Read source

computerra.ru /1 month ago

Как разгрузить 1С: обзор СУБД Tantor Postgres

Источник: Компьютерра - Журнал о науке и технологиях За последние несколько лет СУБД на базе PostgreSQL стали фактическим стандартом для эксплуатации систем на платформе «1С:Предп...

Read source

habr.com /1 month ago

[Перевод] Заглядывая в будущее: Postgres 19. REPACK, SQL/PGQ и умный autovacuum

У каждого релиза Postgres свой характер.Одни релизы строятся вокруг громкой фичи. Другие решают давнюю проблему. Третьи содержат небольшие улучшения, которые замечаешь только после...

Read source

vexpose.blog /2 days ago

Your pgvector Search Gets Slower as You Add Data. Here’s the Setting Everyone Misses.

<p class="wp-block-paragraph">Your semantic search was instant at ten thousand rows. At two million it&#8217;s 800 milliseconds and climbing, and you never</...

Read source

aws.amazon.com /2 weeks ago

CORTO’s billion-scale legal semantic search with Aurora PostgreSQL pgvector

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...

Read source

sourcetrail.com /5 days ago

PostgreSQL 19 Adds SQL/PGQ Graph Queries, While Critical Flaw and AWS Migration Tools Shape the Ecosystem

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...

Read source

rubyflow.com /1 month ago

Moving 300GB of Request Details Out of Postgres

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...

Read source

javacodegeeks.com /1 month ago

PostgreSQL Job Scheduling with pg_cron

Modern applications frequently require background jobs such as cleaning expired sessions, refreshing materialized views, archiving historical data, sending notifications, or genera...

Read source

sourcetrail.com /5 days ago

PostgreSQL 19 Adds Native SQL/PGQ Graph Queries, While Critical Flaw CVE-2026-6471 Patched Across All Supported Versions

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...

Read source

brentozar.com /2 weeks ago

How to Download the Stack Overflow Database for Postgres

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...

Read source

habr.com /1 month ago

Миграция MariaDB → PostgreSQL без даунтайма: почему обычные утилиты не подошли и как мы сделали это через Debezium CDC

Перед командой, выросшей на MySQL/MariaDB, встаёт вопрос перехода на PostgreSQL: лицензии, экосистема расширений, более предсказуемое поведение при конкурентных нагрузках - причин...

Read source

habr.com /2 days ago

Как ускорить выборку из больших таблиц PostgreSQL без ручного создания индексов: разбираем iHeap

Что, если индекс не нужно создавать вообще? Знакомимся с iHeap — альтернативным методом доступа к таблицам PostgreSQL, где BRIN-индексирование встроено «из коробки» и работает авто...

Read source

aws.amazon.com /1 month ago

Migrating mission-critical payments at Nubank to Amazon Aurora PostgreSQL

Managing payment infrastructure at scale presents unique challenges that impact both performance and operational efficiency. In this post, we share the technical and operational ch...

Read source

theregister.com /1 month ago

After rewriting SQLite in Rust, Turso turns its sights on Postgres

Cloud database upstart wants one virtual machine core to power multiple SQL frontends

Read source

habr.com /1 month ago

Postgresso #6 (91)

pgrust это СУБД или злая шутка?Майкл Мэйлис (Michael Malis), житель Сан Франциско, основатель freshpaint‑io, работал в компании Heap — человек в мире Postgres не слишком известный,...

Read source

habr.com /1 month ago

MinIO, MongoDB, PostgreSQL для хранения 25 лет истории стоимости акций

💾 MinIO, MongoDB, PostgreSQL для хранения 25 лет истории стоимости акцийКогда строишь эмулятор для проверки торговой стратегии 20 акций на 25 лет исторических данных поминутно, вы...

Read source

tenderlovemaking.com /1 month ago

Detecting Full Table Scans With SQLite

Originally appeared on Tenderlove Making.I’m at RubyConf this week, and it’s great! I recently read that lobste.rs is now running on SQLite. One part from the post caught my attent...

Read source

habr.com /3 weeks ago

HA: Отказоустойчивость PostgreSQL. Transaction Guard

При создании отказоустойчивых систем стремятся гарантировать отсутствие потерь транзакций при восстановлении из бэкапов или при переключении на реплику (резервный кластер баз данны...

Read source

kodekloud.com /1 week ago

Why Is My SQL Query Slow? It's Almost Never the Hardware

Why is my SQL query slow? Watch EXPLAIN ANALYZE turn a million-row scan into ten block reads with one index, and count an N+1 loop in the act.

Read source

aws.amazon.com /1 month ago

Rebuild large indexes on Aurora PostgreSQL with Blue/Green Deployments

In this post, we show how to rebuild large indexes on Amazon Aurora PostgreSQL by combining Amazon Aurora Blue/Green Deployments with Aurora Optimized Reads. By performing the rein...

Read source

aws.amazon.com /3 weeks ago

Understand memory management in Amazon RDS for PostgreSQL to avoid out of memory

PostgreSQL out-of-memory (OOM) events and excessive disk spilling are among the most common production incidents on Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL. Learn ho...

Read source

mensfeld.pl /4 weeks ago

Ruby and Rails Performance Roundup: The Backlog Edition

Originally appeared on Closer to Code.Yet again instead of tweets, a blog post. The backlog got out of hand - 40 of them this time. Usual caveat: every number below is whatever the...

Read source

Turn fresh research into a full content calendar

Use SocialBu to discover ideas, generate post drafts, and schedule them across your social channels.