Latest updates 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:

  • Postgresso 4 (89)
  • PostgreSQL 18 on Amazon Aurora and Amazon RDS: Security, monitoring, and developer enhancements
  • PostgreSQL 18 on Amazon Aurora and Amazon RDS: Security, monitoring, and developer enhancements

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 month ago

Postgresso 4 (89)

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

Read source
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
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
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
habr.com /2 weeks ago

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

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

Read source
habr.com /1 month ago

PG_EXPECTO 10.1.3: Новые возможности нагрузочного тестирования СУБД PostgreSQL

Официальное предупреждение (дисклеймер)Настоящая статья подготовлена с использованием технологий искусственного интеллекта.В частности:— экспериментальные данные обработаны и проан...

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
habr.com /4 weeks ago

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

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

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
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
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
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
theregister.com /1 month ago

PostgreSQL backup tool gets some backup of its own after sole maintainer sounds alarm

AWS, Percona, Supabase, pgEdge, and Tiger Data rally round pgBackRest with funding pledge

Read source
aws.amazon.com /1 month ago

Index types supported in Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL using extensions (Bloom, pg_trgm, and pg...

In Part 1, Part 2, and Part 3 of this series, we explored PostgreSQL’s native indexes (B-tree, GIN, GiST, HASH, BRIN) and specialized extension-based index types (SP-GiST, btree_gi...

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
habr.com /15 hours ago

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

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

Read source
databricks.com /2 weeks ago

What Is Serverless PostgreSQL?

Serverless PostgreSQL (Postgres) is a fully managed cloud database model that decouples compute and storage...

Read source
dev.to /1 month ago

ParadeDB NPM Package Seeks Feedback on Simplifying Postgres Integration with JavaScript via Drizzle ORM

Introduction: Bridging the Gap Between Postgres and JavaScript with ParadeDB The ParadeDB NPM package emerges as a targeted solution to a growing pain point in modern web develop...

Read source
aws.amazon.com /1 month ago

Automate Oracle PL/SQL to PostgreSQL migration with Amazon Bedrock and Strands Agents

In this post, you learn how to build a generative AI–powered migration assistant that helps automate portions of the last mile of code conversion. Using Anthropic’s Claude Sonnet 4...

Read source
habr.com /1 day ago

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

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

Read source
habr.com /2 weeks ago

Как настроить глубокий и понятный мониторинг для PostgreSQL с ИИ на основе Prometheus, TaskTracker и Pipeliner

Представьте парк из более чем 700 экземпляров СУБД. Классический сценарий: приходит оповещение о высокой нагрузке, администратор начинает вручную собирать метрики с десятков дашбор...

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 /1 month ago

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

HTAP — одна из главных тем в мире СУБД. Вокруг 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.

Sources covering Postgresql

aws.amazon.com

Recent coverage from public sources
Public source

dev.to

Recent coverage from public sources
Public source

habr.com

Recent coverage from public sources
Public source

sdtimes.com

Recent coverage from public sources
Public source

databricks.com

Recent coverage from public sources
Public source

freelancer.com

Recent coverage from public sources
Public source