Release blog post for the 12.0 release of the Citus extension to Postgres. Dive into new Citus 12 features such as schema-based sharding for multi-tenant SaaS applications (and microservices) as well improvements in the Citus support for the Postgres 15 MERGE feature.

Taking a look at one possibility of changing the data type on a column in a big table with minimal impact.

Nobody likes it when their database goes down for any reason, especially if it was unintentional. Sometimes companies are open about their experiences and provide post-mortems for the world to see, and we commend them for it. As Postgres experts, we want to take one of these and see what lessons were learned through the process, and how catastrophe may have been averted.

This article discusses how subqueries perform in PostgreSQL and how to rewrite queries to improve their performance.

Source of Truth: PostgreSQL

Generate Typescript types from Postgres. Contribute to kristiandupont/kanel development by creating an account on GitHub.

etcd is the brain of every Kubernetes cluster, the key-value storage keeping track of all the objects in a cluster. It's intertwined and tightly...

Learn how to analyze memory usage problems, debug memory leaks in PostgreSQL. Memory context manages private memory to process SQL statements. See how.

Chris has some tips on helping you get the most out of queries when working with a remote Postgres foreign data wrapper. He has an overview of how queries are executed with the fdw and then samples for using CTEs, sub-queries, materialized views, and more.

How to locate unused indexes in Postgres 16 and earlier

Easily setup logical replication and switchover to new database with minimal downtime - GitHub - shayonj/pg_easy_replicate: Easily setup logical replication and switchover to new database with mini...

In the fast-moving open-source world, programs can come and go quickly; a tool that has many users today can easily be eclipsed by something better next week. Even in this environment, though, some programs endure for a long time. As an example, consider the PostgreSQL database system, which traces its history back to 1986. Making fundamental changes to a large code base with that much history is never an easy task. As fundamental changes go, moving PostgreSQL away from its process-oriented model is not a small one, but it is one that the project is considering seriously.

Train and deploy models to make online predictions using only SQL, with an open source Postgres extension.

Learn how retrieval plugins—combined with pgvector—can enable you to do amazing things with PostgreSQL on Azure.

Calculate the difference between each record and the previous or next one.

Hyperloglog is a Postgres extension for doing high-compression storage and query approximations. Chris shows you how to get started building a metrics system inside your Postgres database while saving on storage space and query time.

I’m excited to announce that the translation of the “ PostgreSQL 14 Internals ” book is finally complete thanks to the amazing work of Liudmila Mantrova. The final part of the book considers each of the index types in great detail. It explains and demonstrates how access methods, operator classes, and data types work together to serve a variety of distinct needs. You can download a PDF version of this book for free. We are also working on making it available on a print-on-demand service. Your comments are very welcome. Contact us at edu@postgrespro.ru .

A high level overview of the backup options in Postgres. Including pg_dump, pg_basebackup, and pgBackRest.

Authors: Mostafa Abdelraouf, Zain Kabani, Andrew Tanner

Mathesar is a straightforward open source tool that provides a spreadsheet-like interface to a PostgreSQL database. Our web-based interface helps you and your collaborators work with data more independently and comfortably – no technical skills needed.

Web application providing an intuitive user experience to databases.

Integer overflow can happen if you have a sequencing data type exceeding integer limits. Jesse has a query to help you spot it and recommendations for a short term and long term fix.

On a lovely Saturday afternoon our NetOps team raised an alarm: the disk usage on a specific database server was growing fast, and with the current growth rate we have about 30 hours left until the disk is full. Currently climbing over 80%, which triggered the alarm in the first place. Not good. However nothing serious as of now, but better investigate now and not wait until Monday. Zabbix Graph: Space utilization The System This particular server has about 3.

PostgreSQL in Great STYle, Battery-Included Free RDS Alternative!

A semantic version data type for PostgreSQL. Contribute to theory/pg-semver development by creating an account on GitHub.

Unlogged tables in Postgres can give you a big performance improvement but beware of the drawbacks. Here are some tips on how to safely give it a try.

Creating validated data types in Postgres