Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 2 Stunden 23 Minuten

Tatsuo Ishii: What's new in Pgpool-II 4.3 ? (part2)

6. Februar 2022 - 7:23

 In the last blog entry I explained what's new in Pgpool-II 4.3. This is the part 2.

Luca Ferrari: PgTraining online webinar on 2022-04-29 (Italian)

5. Februar 2022 - 1:00

Yet another online event organized by PgTraining!

PgTraining online webinar on 2022-04-29 (Italian)

PgTraining, the amazin italian group of people that spread the word about PostgreSQL and that I joined in the last years, is organizing another online event (webinar) on next 29th April 2022.
Following the success of the previous edition(s), we decided to provide another afternoon full of PostgreSQL talks, in the hope to improve the adoption of this great database.

Greg Sabino Mullane: Secure Permissions for pgBackRest

4. Februar 2022 - 20:42

The pgBackRest tool is a fantastic backup solution for Postgres, with many features including encryption, compression, automatic expiration, PITR, asynchronous archiving, and lots more. By default it runs as the Unix user "postgres" and connects to the database as the "postgres" superuser.

Shaun M. Thomas: PG Phriday: Nominally Bidirectional

4. Februar 2022 - 18:22
Join us this week as we share a dire warning against misusing pglogical in an attempt to achieve bidirectional replication. The end result will likely incur data loss, node divergence, system outages, and be far more of a potential liability than many would expect. From additional necessary management scripts to maintain the facade, to unhandled conflicts mixing data, we’ll discuss just a few of the ways this seemingly innocent attempt at innovation can go wrong. [Continue reading...]

Ryan Booz: Select the most recent record (of many items) with PostgreSQL

4. Februar 2022 - 15:50

Time-series data is ubiquitous in almost every application today. One of the most frequent queries applications make on time-series data is to find the most recent value for a given device or item.

In this blog post, we'll explore five methods for accessing the most recent value in PostgreSQL. Each option has their advantages and disadvantages, which we'll discuss as we go.

Aleksei Kozlov: Vacuuming update-heavy tables

4. Februar 2022 - 15:28

In my previous post I gave an overview of some general parameters that will work well in a standard setting. They might be aggressive, but will allow other processes to work without interruption. Update-heavy tables need special attention when it comes to VACUUM, so in this post I will focus on that.

Takamichi Osumi: How to gain insight into the pg_stat_replication_slots view by examining logical replication

3. Februar 2022 - 1:00

In this blog post I will explain the new system view pg_stat_replication_slots introduced in PostgreSQL, and how you can use it to obtain information on logical replication in your system.

Regina Obe: PostGIS 3.0.5

2. Februar 2022 - 1:00

The PostGIS Team is pleased to release PostGIS 3.0.5.


Continue Reading by clicking title hyperlink ..

Laurenz Albe: Automatic partition creation in PostgreSQL

1. Februar 2022 - 10:00

© Laurenz Albe 2022

Table partitioning is one of the best-liked features out of the more recent PostgreSQL developments. However, there is no support for automatic partition creation yet. This article shows what you can do to remedy that.

Use cases for automatic partition creation

There are essentially two use cases:

Regina Obe: PostGIS 3.1.5

1. Februar 2022 - 1:00

The PostGIS Team is pleased to release PostGIS 3.1.5!


This release is a bug fix release, addressing issues found in the previous 3.1 releases.

Claire Giordano: Call for speakers for Citus Con: An Event for Postgres

31. Januar 2022 - 17:44

When you find yourself answering the same questions again and again, it’s a good idea to blog about it. Which is why this post about Citus Con: An Event for Postgres exists: to answer your questions, and share the news about this first-ever, inaugural event.

Frits Hoogland: The mirage of memory

31. Januar 2022 - 17:02

Modern operating systems like linux are really sophisticated. This sophistication means that sometimes things are actually different than they make you believe. One of these things is memory usage.

Linux, like most modern operating systems, use virtual memory. That means that every distinct process has got its address space, which is completely private to the process, and its threads, if it is using threads.

Andreas 'ads' Scherbaum: Álvaro Herrera

31. Januar 2022 - 15:00
PostgreSQL Person of the Week Interview with Álvaro Herrera: I am a 1976-vintage Chilean tinkerer who grew up disassembling all manner of things and trying to figure out how to put them back again; my father owned a Z80 computer when I was a kid, and I was amazed at some of the things it did, and it led me into developing an interest in doing things with computers. I started my journey with Linux in 1997 and was amazed at the plethora of things I could do with it – that’s where I really learned to program (in Perl).

Tatsuo Ishii: What's new in Pgpool-II 4.3?

31. Januar 2022 - 6:39
  Photo by: pixundfertig
Release note and commit log of Pgpool-II 4.3

In this blog I would like to explain some of new features of the latest Pgpool-II major version 4.3, which was released in December 2021.

David Z: Transaction ID and Snapshot information functions

29. Januar 2022 - 0:46
1. Overview

I recently investigated one internal issue which was related with snapshot and found there were some changes on transaction id and snapshot information functions in PostgreSQL. Here, I am trying to share what I have learned.

Shaun M. Thomas: PG Phriday: Replication Engine Potpourri

28. Januar 2022 - 15:00
Given Postgres’ growing reputation as a leading and preferred relational database system among enterprises and hobbyists alike, it has garnered attention within the database tooling space as well. Some of these tools aim to fill a niche for what they perceive as missing Postgres functionality, while others proclaim Postgres compatibility with their pre-existing software. There are essentially dozens of these in the realm of logical replication technology alone, so why not explore a few of them, and see how they compare to native Postgres capabilities?

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 15 – Add HEADER support to COPY text format

28. Januar 2022 - 12:00
On 28th of January 2022, Peter Eisentraut committed patch: Add HEADER support to COPY text format   The COPY CSV format supports the HEADER option to output a header line. This patch adds the same option to the default text format. On input, the HEADER option causes the first line to be skipped, same as … Continue reading "Waiting for PostgreSQL 15 – Add HEADER support to COPY text format"