Sammlung von Newsfeeds

Jonathan Katz: Using Cert Manager to Deploy TLS for Postgres on Kubernetes

Neues vom PostgreSQL Planet - 2. August 2021 - 21:41

There is no cure-all when it comes to security. Making things open to the public internet can leave you vulnerable to various security risks, including zero-day vulnerabilities or various password attacks.

Andreas 'ads' Scherbaum: Bryn Llewellyn

Neues vom PostgreSQL Planet - 2. August 2021 - 16:00
PostgreSQL Person of the Week Interview with Bryn Llewellyn: I came to PostgreSQL only relatively recently, in the spring of 2019, when I left my job in the PL/SQL Team at Oracle HQ to join Yugabyte Inc. This is an exciting Silicon Valley startup, one of whose founders had been a close colleague of mine in the PL/SQL team. My first blog post in my new job, Why I Moved from Oracle to YugaByte, explains how I was easily persuaded to make this change after close to thirty years with Oracle.

Claire Giordano: What’s new in the Citus 10.1 extension to Postgres

Neues vom PostgreSQL Planet - 30. Juli 2021 - 18:30

Citus 10.1 is out! In this latest release to the Citus extension to Postgres, our team focused on improving your user experience. Some of the 10.1 fixes are operational improvements—such as with the shard rebalancer, or with citus_update_node. Some are performance improvements—such as for multi-row INSERTs or with citus_shards. And some are fixes you’ll appreciate if you use Citus with lots of Postgres partitions.

Ibrar Ahmed: Improve PostgreSQL Query Performance Insights with pg_stat_monitor

Neues vom PostgreSQL Planet - 30. Juli 2021 - 15:50

Understanding query performance patterns is essentially the foundation for query performance tuning. It, in many ways, dictates how a database cluster evolves. And then there are obviously direct and indirect cost connotations as well.

Hans-Juergen Schoenig: PostgreSQL Security: Things to avoid in real life

Neues vom PostgreSQL Planet - 29. Juli 2021 - 10:00

Hardening PostgreSQL has become ever more important. Security is king these days and people want to know how to make PostgreSQL safe. Some of us might still remember what happened to MongoDB in recent years and we certainly want to avoid similar security problems in the PostgreSQL world.

Egor Rogov: Locks in PostgreSQL: 4. Locks in memory

Neues vom PostgreSQL Planet - 28. Juli 2021 - 2:00

To remind you, we've already talked about relation-level locks, row-level locks, locks on other objects (including predicate locks) and interrelationships of different types of locks.

The following discussion of locks in RAM finishes this series of articles. We will consider spinlocks, lightweight locks and buffer pins, as well as events monitoring tools and sampling.

Kat Batuigas: Postgres Full-Text Search: A Search Engine in a Database

Neues vom PostgreSQL Planet - 27. Juli 2021 - 16:58

Early in on my SQL journey, I thought that searching for a piece of text in the database mostly involved querying like this:

SELECT col FROM table WHERE col LIKE '%some_value%';

Then I would throw in some wildcard operators or regular expressions if I wanted to get more specific.

Michael Christofides: Increasing max parallel workers per gather in Postgres

Neues vom PostgreSQL Planet - 27. Juli 2021 - 12:37

Over the past 5 years, new Postgres versions have been getting better and better at running operations in parallel.

This is especially useful for analytical queries, which can sometimes speed up massively by fully utilising a large server (with lots of cores).

However, for fast, transactional queries, the overhead of starting and managing processes is almost always undesirable. As such, the default settings in Postgres are on the conservative side.

Bo Peng: Deploying Pgpool-II Exporter with Docker

Neues vom PostgreSQL Planet - 27. Juli 2021 - 4:00

Pgpool-II Exporter is an open source exporter which exposes Pgpool-II and PostgreSQL cluster's metrics which can be collected by Prometheus. In this previous post, I described how to build and run Pgpool-II Exporter on a local machine.

Luca Ferrari: pgbackrest async behavior

Neues vom PostgreSQL Planet - 27. Juli 2021 - 2:00

pgbackrest can work in asynchronous way in order to improve the resource usage.

Pavel Stehule: pspg 5.2.0 released

Neues vom PostgreSQL Planet - 26. Juli 2021 - 22:39

There are only two, but I hope important, features.

First feature is "progressive data load". Before this release, pspg loaded all rows before first print to screen. Now, with progressive data load, only 500 rows are loaded, these rows are printed to screen, and repeatedly next 2000 rows are loaded. Although the load should not be complete, almost all pspg commands can be used.  

Jeremy Schneider: PostgreSQL Logical Replicas and Snapshots: Proceed Carefully

Neues vom PostgreSQL Planet - 26. Juli 2021 - 18:52

Earlier this year, Christos Christoudias – an Engineer from Instacart – published an article on Medium about Creating a Logical Replica from a Snapshot in RDS Postgres. Recently I’ve seen discussions about this article a few times, in a few different places. Is it safe? Is it ok to do this?

Joshua Drake: August PostgresWorld Webinars

Neues vom PostgreSQL Planet - 26. Juli 2021 - 18:21

As North America starts to reopen, the PostgresWorld webinar series continues to provide exceptional free content to the community. See below for the August webinars.

Andreas 'ads' Scherbaum: Roman Druzyagin

Neues vom PostgreSQL Planet - 26. Juli 2021 - 16:00
PostgreSQL Person of the Week Interview with Roman Druzyagin: Name’s Roman. I’ve been born and lived most of my life in Russia. I grew up near Moscow, and since 2002 I’ve been residing in St. Petersburg, with plans to relocate to the European Union in the near future. I am currently 33 years old.

David Z: The Amazing Buffer Tag in PostgreSQL

Neues vom PostgreSQL Planet - 23. Juli 2021 - 23:59
1. Overview

I was working on the PostgreSQL storage related features recently, and I found PostgreSQL has designed an amazing storage addressing mechanism, i.e. Buffer Tag. In this blog, I want to share with you my understanding about the Buffer Tag and some potential usage of it.

Paul Ramsey: Waiting for PostGIS 3.2: ST_Contour and ST_SetZ

Neues vom PostgreSQL Planet - 23. Juli 2021 - 20:33

One theme of the 3.2 release is new analytical functionality in the raster module, and access to cloud-based rasters via the "out-db" option for rasters. Let's explore two new functions and exercise cloud raster support at the same time.

Paul Brebner: Streaming JSON Data Into PostgreSQL Using Open Source Kafka Sink Connectors (Pipeline Series Part 6)

Neues vom PostgreSQL Planet - 23. Juli 2021 - 1:56

Having explored one fork in the path (Elasticsearch and Kibana) in the previous pipeline blog series (here is part 5), in this blog we backtrack to the junction to explore the alternative path (PostgreSQL and Apache Superset).

Martin Davis: Using PostGIS and pg_featureserv with QGIS

Neues vom PostgreSQL Planet - 21. Juli 2021 - 18:31

My colleague Kat Batuigas recently wrote about using the powerful open-source QGIS desktop GIS to import data into PostGIS from an ArcGIS Feature Service.

Hans-Juergen Schoenig: PostgreSQL zheap: Current status

Neues vom PostgreSQL Planet - 20. Juli 2021 - 10:00

zheap has been designed as a new storage engine to handle UPDATE in PostgreSQL more efficiently. A lot has happened since my last report on this important topic, and I thought it would make sense to give readers a bit of a status update – to see how things are going, and what the current status is.

Luca Ferrari: PostgreSQL Extension Catalogs

Neues vom PostgreSQL Planet - 20. Juli 2021 - 2:00

How to see the available and/or installed extensions?

PostgreSQL Extension Catalogs

There are three main catalogs that can be useful when dealing with extensions: