Neues vom PostgreSQL Planet

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

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.

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.

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...]

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.

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.

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.

The PostGIS Team is pleased to release PostGIS 3.0.5.

3.0.5

• source download md5
• NEWS
• PDF docs en

Continue Reading by clicking title hyperlink ..

© 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:

The PostGIS Team is pleased to release PostGIS 3.1.5!

3.1.5

• source download md5
• NEWS
• PDF docs en

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

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.

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.

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).

  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.

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.

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?

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"