Social Media Ideas for Postgres

Latest updates for Postgres

Fresh curated links around postgres 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.

dev.to /4 weeks ago

PostgreSQL 18 on Amazon Aurora and Amazon RDS: Security, monitoring, and developer enhancements

PostgreSQL 18 brings several security, monitoring, and developer enhancements relevant to Amazon RDS and Aurora PostgreSQL users. Key changes include: deprecation of MD5 password a...

Read source

habr.com /1 month ago

Postgresso 4 (89)

PostgreSQL: PostgreSQL 19 Beta 1Официальный релиз запланировали на сентябрь/октябрь. Вот что старейшины решили выделить в описании релиза 19-й версии:ПроизводительностьPostgreSQL 1...

Read source

dev.to /1 month ago

PostgreSQL change data capture governed Apache Iceberg / Parquet on AWS S3 вЂ” built for AI agents.

Core Features pg-cdc is not just replication. pg-cdc streams Postgres Write Ahead Logs(WAL) out of production Postgres into typed, immutable, time-travelable Iceberg tables on S3...

Read source

dev.to /1 month ago

Prisma query logging y PostgreSQL: dГіnde termina el ORM y empieza la base

Prisma query logging y PostgreSQL: dГіnde termina el ORM y empieza la base ActivГ© query logging en Prisma, vi los queries llegando a la consola, y asumГ que tenГa visibilidad...

Read source

snowflake.com /4 weeks ago

Snowflake Postgres Unifies Your Apps, Analytics and AI

Snowflake Postgres now offers data mirroring and pg_lake integration — a native, pipeline-free way to sync OLTP and analytical data in near real time.

Read source

dev.to /1 month ago

Prisma Query Logging and PostgreSQL: Where the ORM Ends and the Database Begins

Prisma Query Logging and PostgreSQL: Where the ORM Ends and the Database Begins I turned on query logging in Prisma, watched queries rolling into the console, and assumed I had f...

Read source

habr.com /1 month ago

Миграции в Go-проекте: PostgreSQL в Docker и goose на практике

Когда я начал поднимать PostgreSQL через Docker для своих проектов, всё выглядело просто: описал сервис в docker-compose.yml, запустил контейнер - база доступна.Проблемы начались к...

Read source

javacodegeeks.com /2 days 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

dev.to /1 month ago

Optimistic concurrency is the whole design: event sourcing on Aurora DSQL

Quorum is an incident command plane built on Amazon Aurora DSQL. The failover story lives in another post. This one is about a narrower question that turned out to be the foundatio...

Read source

dev.to /16 hours ago

Realtime Without a WebSocket Service

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

Read source

aws.amazon.com /4 weeks ago

PostgreSQL 18 on Amazon Aurora and Amazon RDS: Security, monitoring, and developer enhancements

In Part 1 of this series, we explored the performance enhancements in PostgreSQL 18, including skip scan optimization, enhanced EXPLAIN output, automatic self-join removal, and vac...

Read source

dataengineeringcentral.substack.com /1 month ago

Spark. Postgres. Duplicates. Dang it.

a lesson in fundamentals

Read source

habr.com /4 weeks ago

PostgreSQL 19 Beta: неблокирующий REPACK — перепаковка раздутых таблиц без окна простоя (и графовые запросы в придачу)

4 июня 2026 вышла PostgreSQL 19 Beta 1. Все пишут про графовые запросы SQL/PGQ, но главная операционная новость в другом: в ядро завезли команду REPACK с неблокирующей опцией CONCU...

Read source

habr.com /1 month ago

Пап, а это HTAP? — Ну такое, это две разные СУБД в длинном плаще

HTAP — одна из главных тем в мире СУБД. Вокруг PostgreSQL массово появляются конструкции с внешними аналитическими движками со своими моделями хранения данных и ограничениями совме...

Read source

freelancer.com /1 month ago

Universal Postgres CRUD Utility

I need a reusable SQL/PL-pgSQL routine that can handle Create, Read and Update actions against any table in my PostgreSQL database. Table names, column sets and primary keys will b...

Read source

sdtimes.com /1 month ago

EDB Releases PGD 6.4 with Quorum Commit, Bringing True Distributed Consistency to Mission-Critical Postgres

WILMINGTON, Del. — EnterpriseDB (EDB), the leading sovereign AI and data company, has announced EDB Postgres Distributed (PGD) 6.4, the distributed transactional foundation of EDB...

Read source

sqlservercentral.com /1 week ago

Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables

Every PostgreSQL migration eventually hits the same fork in the road. The database is small enough to dump and restore in a maintenance window, or it isn't. Once you... The post Mo...

Read source

habr.com /2 weeks ago

Диапазонный тип данных в PostgreSQL: ускоряем запросы

Привет, Хабр! Пишет эту статью Александра Лысенко — вчера я была студенткой, а сегодня как инженер-программист Nexign спешу поделиться приобретенным опытом. Мой первый проект для р...

Read source

rubyflow.com /3 days 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

aws.amazon.com /1 week ago

Logical replication improvements in Amazon RDS for PostgreSQL 18

In this post, we demonstrate how to use the PostgreSQL 18 logical replication improvements on RDS for PostgreSQL: replicating STORED generated columns with the publish_generated_co...

Read source

aws.amazon.com /4 weeks ago

PostgreSQL 18 on Amazon Aurora and Amazon RDS: Performance enhancements

This is Part 1 of a two-part series covering the key features in PostgreSQL 18. In this post, we focus on performance enhancements: skip scan optimization for multicolumn indexes,...

Read source

aws.amazon.com /1 week ago

Automate PostgreSQL audit log extraction and analysis with Amazon S3

In this post, we show you how to deploy an automated pipeline that extracts PostgreSQL audit logs from CloudWatch Logs, converts them into structured comma-separated values (CSV) f...

Read source

aws.amazon.com /1 month ago

Real-time CDC from Aurora PostgreSQL to Amazon S3 Tables using Debezium and Firehose

In this post, we show you how to build a CDC pipeline that delivers query-ready Iceberg tables directly. The pipeline captures inserts, updates, and deletes from Aurora PostgreSQL...

Read source

habr.com /16 hours ago

[Перевод] Проектирование системы хранения POSTGRES

Мы продолжаем праздновать 30-летие PostgreSQL и публикуем перевод второй фундаментальной статьи о СУБД. Перевод первого манифеста можно прочесть в этом посте. Читать далее

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.