Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 34 Minuten 3 Sekunden

Jonathan Katz: Encrypting Postgres Data at Rest in Kubernetes

25. Oktober 2021 - 20:58

Encrypting data at rest is often an important compliance task when working on securing your database system.

Jagadeesh Panuganti: Migration Management and schema version control in PostgreSQL

25. Oktober 2021 - 20:54

Version control of any code is essential for every organization. All organizations use their own preferred tools like git, svn, perforce etc. As I was working on a new requirement, which is about porting the current CI/CD pipeline to PostgreSQL, I needed to look for a tool which will take care of the schema changes. In this use case, the customer is maintaining all the schema in a separate directory, and creating the objects/schema during the application bootstrap process.

Andreas 'ads' Scherbaum: Alexander Kukushkin

25. Oktober 2021 - 16:00
PostgreSQL Person of the Week Interview with Alexander Kukushkin: My name is Alexander. Originally I am from Russia. Since 2013 I live in Berlin and work as a Database Engineer at Zalando.

Regina Obe: PostGIS 3.2.0beta1 Released

23. Oktober 2021 - 2:00

The PostGIS Team is pleased to release the first beta of the upcoming PostGIS 3.2.0 release.

Hubert 'depesz' Lubaczewski: Why is it hard to automatically suggest what index to create?

22. Oktober 2021 - 21:43
Every now and then someone asks me to add index suggestions to I always respond with polite decline. This is complicated thing to do, and I just have that time. Lately I was asked, on Slack to add (to link to pganalyze Index Advisor for Postgres. So I checked it out. And results … Continue reading "Why is it hard to automatically suggest what index to create?"

Suman Michael: Organizing PostgreSQL codebase using templates in Golang

22. Oktober 2021 - 21:15

While migrating to PostgreSQL, have you ever wondered whether you could make changes to SQL-only code without triggering a build, re-deployment, or even a restart? Have you ever attempted packaging software as a binary and allowing clients to execute their own compatible queries on any DB engine at no additional cost? In such cases, a better approach to organizing SQL queries in Golang is required. We recently developed an in-house micro-service using golang and PostgreSQL by leveraging the go's template language feature.

Burak Velioğlu: How to scale Postgres for time series data with Citus

22. Oktober 2021 - 17:49

Managing time series data at scale can be a challenge. PostgreSQL offers many powerful data processing features such as indexes, COPY and SQL—but the high data volumes and ever-growing nature of time series data can cause your database to slow down over time.

Fortunately, Postgres has a built-in solution to this problem: Partitioning tables by time range.

REGINA OBE: FOSS4G 2021 Bueno Aires Videos are out

21. Oktober 2021 - 19:37

The Free and Open Source for GIS conference : FOSS4G 2021 Bueno Aires Online took place September 27th to October 2nd, 2021 online. Many of the videos from the conference (including mine on PostGIS) are at FOSS4G 2021 Playlist viewable online.

Ryan Booz: What is ClickHouse, how does it compare to PostgreSQL and TimescaleDB, and how does it perform for time-series data?

21. Oktober 2021 - 15:43

Over the past year, one database we keep hearing about is ClickHouse, a column-oriented OLAP database initially built and open-sourced by Yandex.

In this detailed post, which is the culmination of 3 months of research and analysis, we answer the most common questions we hear, including:

Álvaro Hernández: StackGres 1.0.0: Open Source Postgres-aaS with 120+ Extensions

21. Oktober 2021 - 14:08
StackGres 1.0.0: Open Source Postgres-aaS with 120+ Extensions TL;DR

We’re announcing StackGres 1.0.0 GA. StackGres is an Open Source Postgres-as-a-Service that runs on any Kubernetes environment. StackGres, today, is the Postgres platform with the most Postgres extensions available: 120 as of today. Many more to come in the future.

Haiying Tang: What is the new LZ4 TOAST compression in PostgreSQL 14, and how fast is it?

21. Oktober 2021 - 2:03

The new column compression option LZ4 introduced in PostgreSQL 14 provides faster compression. How can I use it, and how much faster is it? 

Franck Pachot: Boosts Secondary Index Queries with Index Only Scan

20. Oktober 2021 - 23:20

Originally published at with YugabyteDB in mind, because the benefit of Index Only Scan is huge in a distributed database. It also applies to PostgreSQL, knowing that the hops to the table pages are saved only for the vacuumed part of the table.

Dave Page: 5 Cloud Architecture Considerations That Every Enterprise Should Know

20. Oktober 2021 - 15:20
Running databases in the cloud offers the promise of more efficient operations and greater agility. However, there are important architectural and management decisions that often people don’t consider. [Continue reading...]

Laurenz Albe: WITH HOLD cursors and transactions in PostgreSQL

20. Oktober 2021 - 10:00

© Laurenz Albe 2021

Both cursors and transactions are basic ingredients for developing a database application. This article describes how cursors and transactions interact and how WITH HOLD can work around their limitations. We will also see the dangers involved and how to properly use WITH HOLD cursors in a PL/pgSQL procedure.

David Kohn: Function pipelines: Building functional programming into PostgreSQL using custom operators

19. Oktober 2021 - 15:33

Today, we are announcing function pipelines, a new capability that introduces functional programming concepts inside PostgreSQL (and SQL) using custom operators.

Michał Mackiewicz: Does QGIS work with Postgres 14?

19. Oktober 2021 - 12:34

Performing a major upgrade of Postgres cluster poses a very little risk for the database itself. The binary data structure is quite stable (and because of that, a very quick upgrade using the pg_upgrade’s –link option is possible) and it’s highly unlikely that the data can be damaged or lost during the process.

Jonathan Katz: Projecting Monthly Revenue Run Rate in Postgres

18. Oktober 2021 - 21:36

Monthly recurring revenue (MRR) and annual recurring revenue (ARR) are important metrics for a subscription-based business model. It allows for the business to project its available capital to make important decisions around expansion, hiring and more.

Nikolay Samokhvalov: Useful queries to analyze PostgreSQL lock trees (a.k.a. lock queues)

18. Oktober 2021 - 19:05
For OLTP workloads (such as web and mobile applications), it is important to understand object-level and row-level locks in PostgreSQL. There are several good materials that I can recommend reading:

Andreas 'ads' Scherbaum: Ivan Panchenko

18. Oktober 2021 - 16:00
PostgreSQL Person of the Week Interview with Ivan Panchenko: My name is Ivan Panchenko, I live in Moscow, Russia. I am 49 now. Married, 5 children (already grown up).

Paul Brebner: Kafka Connect and Elasticsearch vs. PostgreSQL Pipelines: Final Performance Results (Pipeline Series Part 9)

18. Oktober 2021 - 15:10

In Part 6 and Part 7 of the pipeline series we took a different path in the pipe/tunnel and explored PostgreSQL and Apache Superset, mainly from a functional perspective—how can you get JSON data into PostgreSQL from Kafka Connect,