Neues vom PostgreSQL Planet

Neues vom PostgreSQL Planet Feed abonnieren
Planet PostgreSQL
Aktualisiert: vor 3 Stunden 1 Minute

Luca Ferrari: pg_upgrade and OpenBSD

5. November 2021 - 1:00

OpenBSD ships pg_upgrade as a separate package.

pg_upgrade and OpenBSD

I never noted that, on OpenBSD, the pg_upgrade command is not shipped with the default PostgreSQL server isntallation. I usually install PostgreSQL from sources, so I never digged into Open BSD packages. The choice of OpenBSD is to keep pg_upgrade separate from the rest of the binaries and executables of PostgreSQL.
Allow me to explain and let’s start from the installed binaries on a OpenBSD 7.0 machine:



Jonathan Katz: Can't Resize your Postgres Kubernetes Volume? No Problem!

4. November 2021 - 19:50

You've built an application and are using Postgres to run it. You move it into production. Things are going great. So great that you've accumulated so much data that you need to resize your disk.

Frits Hoogland: Cloud: IO limits gone full circle

4. November 2021 - 15:15

In the old days we used rotating disks, which had mechanical arms moving over the surface to read data, which meant there was a certain latency before data could be obtained, and a limited amount of bandwidth. The solution for getting more bandwidth was to use more disks (RAID). Still the overall usage was essentially bound by IOPS because of the mechanical arms/attenuators. (there was other storage media before that, but that is outside of the scope of this article)

Frits Hoogland: Cloud: IO limits gone full circle

4. November 2021 - 15:15

In the old days we used rotating disks, which had mechanical arms moving over the surface to read data, which meant there was a certain latency before data could be obtained, and a limited amount of bandwidth. The solution for getting more bandwidth was to use more disks (RAID). Still the overall usage was essentially bound by IOPS because of the mechanical arms/attenuators. (there was other storage media before that, but that is outside of the scope of this article)

Nikolay Samokhvalov: Three Cases Against IF NOT EXISTS / IF EXISTS in Postgres DDL

3. November 2021 - 22:45
What is this about?

Many DDL statements in PostgreSQL support modified IF EXISTS / IF NOT EXISTS. For example:

test=# create table if not exists mytable(); CREATE TABLE test=# drop table if exists mytable; DROP TABLE

I recommend using `IF EXISTS` / `IF NOT EXISTS` in DDL only when necessary. Here are three examples that demonstrate how the overuse of these words may lead to negative consequences.

Caitlin Strong: Patroni & etcd in High Availability Environments

3. November 2021 - 15:50

Crunchy Data products often include High Availability. Patroni and etcd are two of our go-to tools for managing those environments. Today I wanted to explore how these work together. Patroni relies on proper operation of the etcd cluster to decide what to do with PostgreSQL.

Franck Pachot: Open-source🍃MongoDB API to 🚀YugabyteDB with 🥭MangoDB proxy

3. November 2021 - 14:59

There is no doubt that one great thing about MongoDB is the API. Many developers loves it. I'm a big fan of SQL, but we need to listen to all users, and they have use-cases for it. Another thing we expect from NoSQL is the scalability.

In this example we have both, open-source, ACID and resilient, with

Pavel Stehule: pspg 5.5.0

2. November 2021 - 17:42

 Today I released pspg 5.5. There are few new interesting features:

Lukas Fittl: How we deconstructed the Postgres planner to find indexing opportunities

2. November 2021 - 9:45
Everyone who has used Postgres has directly or indirectly used the Postgres planner. The Postgres planner is central to determining how a query gets executed, whether indexes get used, how tables are joined, and more. When Postgres asks itself "How do we run this query?”, the planner answers. And just like Postgres has evolved over decades, the planner has not stood still either. It can sometimes be challenging to understand what exactly the Postgres planner does, and which data it bases its…

cary huang: The PostgreSQL Timeline Concept

1. November 2021 - 21:53
1. Introduction

In my previous blog here, I discussed about PostgreSQL’s point in time recovery where PostgreSQL supports an ability to recover your database to a specific time, recovery point or transaction ID in the past but I did not discuss in detail the concept of timeline id, which is also important in database recovery.

Andreas 'ads' Scherbaum: Tatsuro Yamada

1. November 2021 - 15:00
PostgreSQL Person of the Week Interview with Tatsuro Yamada: I was born in Hokkaido, a prefecture in the north part of Japan, and I live near Tokyo now. I work as an in-house database engineer at NTT Comware, providing technical support, product verification, and human resource education for PostgreSQL. And I’m contributing to the PostgreSQLcommunity by developing useful features for DBAs, and by reporting problems.

Pavel Stehule: Orafce 3.17.0

31. Oktober 2021 - 18:05
I released Orafce 3.17.0. This is bugfix only release. Giles Darold wrote a patch that fixes orafce's regexp functions for NULL arguments.

Nikolay Samokhvalov: How partial, covering, and multicolumn indexes may slow down UPDATEs in PostgreSQL

30. Oktober 2021 - 1:55

Based on a true story.

This article was originally published in 2018. This is a reviewed and extended version of it. The discussed findings can be applied to any actual major version of PostgreSQL.

Luca Ferrari: Perl Weekly Challenge 136: PostgreSQL Solutions

29. Oktober 2021 - 2:00

My personal solutions to the Perl Weekly Challenge, this time in PostgreSQL!

Doug Hunley: Secure PostgreSQL 14 with CIS Benchmark

28. Oktober 2021 - 16:22

Crunchy Data is proud to announce an update to the CIS PostgreSQL Benchmark by the Center for Internet Security (CIS). CIS is a nonprofit organization that publishes best practices and standards for securing modern technology and systems.

Franck Pachot: COPY progression in YugabyteDB

28. Oktober 2021 - 16:19

When you want to evaluate the migration from PostgreSQL to YugabyteDB you may:

  • load metadata (DDL) from a pg_dump
  • load data with pg_restore
  • test the application

Here are some quick scripts that I've used for that. And it can give an idea of what can be done to import data from a http endpoint in JSON into a PostgreSQL table.

Luca Ferrari: pspg lands in OpenBSD

28. Oktober 2021 - 2:00

A great pager into a great operating system.

Laurenz Albe: TCP keepalive for a better PostgreSQL experience

27. Oktober 2021 - 10:00


© Laurenz Albe 2021

If you’ve heard about TCP keepalive but aren’t sure what that is, read on. If you’ve ever been surprised by error messages like:

  • server closed the connection unexpectedly
  • SSL SYSCALL error: EOF detected
  • unexpected EOF on client connection
  • could not receive data from client: Connection reset by peer

then this article is for you.

Causes for broken connections

There are several possible causes for broken connections:

Jonathan Katz: Database Security Best Practices on Kubernetes

26. Oktober 2021 - 17:43

As more data workloads shift to running on Kubernetes, one of the important topics to consider is security of your data.

Seiten