Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 1 Stunde 58 Minuten

Robert Haas: Don't Manually Modify The PostgreSQL Data Directory!

11. Mai 2020 - 18:07
I was lucky enough to get a chance to give my talk Avoiding, Detecting, and Recovering From Data Corruption at PGCONF.IN in February, before everything got shut down. The conference organizers did an amazing job with the video, which shows both me speaking and the slides I was presenting side by side. That's the first time a PostgreSQL conference has done the video that way, and I love it.

Andreas 'ads' Scherbaum: Fabrízio de Royes Mello

11. Mai 2020 - 16:00
PostgreSQL Person of the Week Interview with Fabrízio de Royes Mello: Hi, I’m Fabrízio. I was born and live in the southern part of Brazil, in a city called Bagé. It’s close to the border with Uruguay. I’m married and have four daughters. Also I have three cats, one dog and two mices. I love to spend time with my family and friends. I like watching movies, series and sports (soccer, martial arts, volleyball).

Amit Kapila: Improved (auto)vacuum in PostgreSQL 13

11. Mai 2020 - 6:20
Vacuum is one of the sub-systems in PostgreSQL which gets improved with each release.  I have checked past five releases and each has quite a few improvements for vacuum.  Following the trend, there are a number of improvements in vacuum in the upcoming PostgreSQL release (v13) which are covered in this blog.

Bruce Momjian: Postgres Internals Website

8. Mai 2020 - 17:30

I am often asked how someone can learn more about Postgres, particularly the internals. There is the Postgres developer page, which has links to many resources, and the developer's FAQ item about learning about the internals.

Hans-Juergen Schoenig: PostgreSQL: now() vs. ‘NOW’::timestamp vs. clock_timestamp()

8. Mai 2020 - 9:00

Everybody who has ever written any kind of database application had to use time and date. However, in PostgreSQL there are some subtle issues most people might not be aware of. To make it easier for beginners, as well as advanced people, to understand this vital topic I have decided to compile some examples which are important for your everyday work.

Gabriele Bartolini: Local Persistent Volumes and PostgreSQL usage in Kubernetes

7. Mai 2020 - 16:00
Can I use PostgreSQL in Kubernetes and expect to achieve performance results of the storage that are comparable to traditional installations on bare metal or VMs? In this article I go through the benchmarks we did in our own Private Cloud based on Kubernetes 1.17 to test the performance of local persistent volumes using OpenEBS […]

Jonathan Katz: Multi-Kubernetes Cluster PostgreSQL Deployments

7. Mai 2020 - 10:55

Advanced PostgreSQL high-availability and disaster recovery strategies designed to maximize uptime involve distributing database clusters across multiple data centers. While on the surface, this may seem intuitive (e.g.

Bruce Momjian: Portability's Surprising Win

6. Mai 2020 - 14:45

When writing software, it is necessary to decide whether to use external facilities available in command-line tools, libraries, frameworks, and the operating system, or write the facilities yourself. Why would you write them yourself? You might be worried about adding reliance on an external facility or a facility might not have sufficient flexibility or performance.

Robert Haas: Who Contributed to PostgreSQL Development in 2019?

5. Mai 2020 - 18:31
This is my fourth annual post on who contributes to PostgreSQL development. See previous posts in this series for methodology. I calculate that this year, 189 people were primary authors of at least one PostgreSQL commit. 37 of those people accounted for 90% of the new lines, and 12 people accounted for 66% of the new lines. In total, there were 2127 commits by 26 committers.

Jonathan Katz: Deploy pgAdmin4 with PostgreSQL on Kubernetes

5. Mai 2020 - 18:14

Tools like the PostgreSQL Operator make it easy to get PostgreSQL up and running on Kubernetes, but what about actually accessing your Postgres databases?

Liaqat Andrabi: Security and Compliance with PostgreSQL [Webinar]

5. Mai 2020 - 10:06
For businesses handling personal data, the security of their database is a serious matter. Faced with an increasing number of attacks, organizations must improve their security and compliance policies, enhance their database infrastructure, and ensure all proper security protocols are in place. As part of the ongoing PostgreSQL Webinar Series, 2ndQuadrant hosted a webinar on […]

Paul Ramsey: Routing with PostgreSQL and Crunchy Spatial

4. Mai 2020 - 23:28

One of the least-appreciated PostgreSQL extensions is the powerful PgRouting extension, which allows routing on dynamically generated graphs.

Gabriele Bartolini: Backup manifests and pg_verifybackup in PostgreSQL 13

4. Mai 2020 - 18:43
PostgreSQL 13 introduces two useful features to enhance automated validation of physical backups: backup manifests and a new tool called pg_verifybackup. In this short article I attempt to provide an overview of them. As you probably know if you are familiar with PostgreSQL and the PostgreSQL Community, I have been promoting business continuity and disaster […]

Andreas 'ads' Scherbaum: Jimmy Angelakos

4. Mai 2020 - 16:00
PostgreSQL Person of the Week Interview with Jimmy Angelakos: I grew up in Athens, Greece, then went to Scotland to study at the University of Aberdeen. After 15 years of working in the industry with Open Source tools, I found myself working with my favourite database, as Senior PostgreSQL Architect at 2ndQuadrant in Edinburgh. Music is a big part of my life, I love listening to diverse genres, a long time ago I played in a rock band, and in the more recent past I presented a music-oriented radio show.

Bruce Momjian: WITH ... MATERIALIZED and Optimizer Control

4. Mai 2020 - 15:00

Before Postgres 12, queries specified as common table expressions (WITH clauses) always behaved as optimization barriers, meaning that common table expression queries were executed independently, and were not moved to later parts of the query.

Denish Patel: Working With Repmgr: Using Other 3rd Party Tools for Setting up a Standby

4. Mai 2020 - 14:07

For a standby node to be used in a repmgr configuration, it has to be registered.  Normally you do this by allowing repmgr to clone the standby first.  If a node was not cloned by repmgr, you can nonetheless register it using the -F/–force option.  This is useful for cases where you want to use another tool (like pgbackrest) to backup and restore your clusters.

Christoph Berg: arm64 on

4. Mai 2020 - 11:20

The has been extended to cover the arm64 architecture.

We had occasionally received user request to add "arm" in the past, but it was never really clear which kind of "arm" made sense to target for PostgreSQL. In terms of Debian architectures, there's (at least) armel, armhf, and arm64. Furthermore, Raspberry Pis are very popular (and indeed what most users seems to were asking about), but the raspbian "armhf" port is incompatible with the Debian "armhf" port.

Nawaz Ahmed: My Favorite PostgreSQL Extensions - Part Two

1. Mai 2020 - 19:38

This is the second part of my blog “My Favorite PostgreSQL Extensions” wherein I had introduced you to two  PostgreSQL extensions, postgres_fdw and pg_partman. In this part I will explore three more.

Bruce Momjian: Background Writes

1. Mai 2020 - 17:45

Postgres must guarantee durability and good performance. To meet these objectives, Postgres does writes to the file system and storage in the background as much as possible. In fact, there are only two major cases where writes happen in the foreground:

Hamid Akhtar: Optimizing SQL – Step 1: EXPLAIN Costs and Plans in PostgreSQL – Part 2

30. April 2020 - 20:45

This is the second blog in a series of blogs attempting to walk you through the query optimization process. We started from the very basics of understanding the “EXPLAIN” command. Reading part 1 is not a prerequisite, however, if you wish to understand how you can reconstruct a query from a given plan, Optimizing SQL – Step 1: EXPLAIN in PostgreSQL – Part 1 may help.