Sammlung von Newsfeeds

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

Neues vom PostgreSQL Planet - 22. Oktober 2021 - 21:43
Every now and then someone asks me to add index suggestions to explain.depesz.com. 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 explain.depesz.com) 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

Neues vom PostgreSQL Planet - 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.

REGINA OBE: FOSS4G 2021 Bueno Aires Videos are out

Neues vom PostgreSQL Planet - 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.

Franck Pachot: Boosts Secondary Index Queries with Index Only Scan

Neues vom PostgreSQL Planet - 20. Oktober 2021 - 23:20

Originally published at https://blog.yugabyte.com 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

Neues vom PostgreSQL Planet - 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

Neues vom PostgreSQL Planet - 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

Neues vom PostgreSQL Planet - 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?

Neues vom PostgreSQL Planet - 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

Neues vom PostgreSQL Planet - 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)

Neues vom PostgreSQL Planet - 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

Neues vom PostgreSQL Planet - 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)

Neues vom PostgreSQL Planet - 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,

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

Neues vom PostgreSQL Planet - 18. Oktober 2021 - 12:05
PostgreSQL locking issues may be annoying. This blog post provides useful information that will help you understand how PostgreSQL MVCC implements locking and how to troubleshoot locking issues.

David Z: Backup Label in PostgreSQL

Neues vom PostgreSQL Planet - 16. Oktober 2021 - 0:42
1. Overview

When I was working on some backup and recovery related features for a project based on Postgres, I noticed that there is file called backup_label. By quickly google search, you can find some very nice blogs or books which discussed this topic, such as, The Internals of PostgreSQL, one of my favourite books. In this blog, I am going to talk it a little more based on my experience.

Ryan Lambert: Using Query ID in Postgres 14

Neues vom PostgreSQL Planet - 15. Oktober 2021 - 2:30

Postgres 14 was released on September 30, 2021. With a new major version comes new features to explore! This post takes a look at the unique query id option enabled with compute_query_id in postgresql.conf. This particular backend improvement, included with Postgres 14, is one I am excited about because it makes investigating and monitoring query related performance easier.

Jonathan Katz: Multi-Cluster Postgres Federation on Kubernetes with Postgres 14 Using GitOps

Neues vom PostgreSQL Planet - 14. Oktober 2021 - 16:29

One of the reasons why I like deploying Postgres on Kubernetes with PGO, the open source Postgres Operator, is that it makes it easier to set up distributed database systems.

Akhil Reddy Banappagari: Stored Procedure OUT Parameters in PostgreSQL 14

Neues vom PostgreSQL Planet - 14. Oktober 2021 - 10:46

PostgreSQL global development group generally announces a new release every year, with several new features.

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

Neues vom PostgreSQL Planet - 13. Oktober 2021 - 15:06

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

Pavlo Golub: SHOW TABLES in PostgreSQL: what’s wrong with it?

Neues vom PostgreSQL Planet - 13. Oktober 2021 - 10:00

In this article, I will answer the questions: why isn’t there a  SHOW TABLES command in PostgreSQL, when will SHOW TABLES in PostgreSQL be available, and how do I list tables with native PostgreSQL methods?

Why isn’t there a SHOW TABLES command in PostgreSQL?

People who come from MySQL are always asking the same question: why doesn’t the command SHOW TABLES work in PostgreSQL ?

Pavel Stehule: pspg 5.4.1 released

Neues vom PostgreSQL Planet - 13. Oktober 2021 - 8:54
I released bugfix release of pspg. The problem with copy to clipboard on macos (using by pbcopy) is fixed in this release.

Seiten