Neues vom PostgreSQL Planet
Marco Slot: Test drive the Citus 11.0 beta for Postgres
Today we released Citus 11.0 beta, which is our first ever beta release of the Citus open source extension to Postgres. The reason we are releasing a beta version of 11.0 is that we are introducing a few fundamentally new capabilities, and we would like to get feedback from those of you who use Citus before we release Citus 11.0 to the world.
Alexander Nikitin: No UPDATE updates
Working with databases one can’t help but wonder what happens with data stored on the disk.
For example you need to know this to be able to save at least some of the information on damaged data blocks with help of hexedit.
Today we’ll try to find out how data types such as integer are kept on disk. To do that we will create a testing table, review its contents using hexedit and change data on disk. For the sake of this exercise I will be using PostgreSQL 14.
Let’s create a testing table:
Khushboo Vashi: pgAdmin 4 Browser Tree
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 15 – Add support for security invoker views.
Laurenz Albe: Query parameter data types and performance
© Laurenz Albe 2022
Recently, I could help solve a “mysterious” performance problem for a customer. The problem turned out to be a badly chosen query parameter type, which led to poor query performance. After working on this customer’s case, I realized that the meaning of the data type of a query parameter is not universally understood, which is why I decided to write this article.
What are query parameters?In SQL, we often encounter queries that only differ in constant values, for example
Frits Hoogland: Testing an application with a network delay
This blogpost is about a linux feature to introduce delays in sending packets on the network.
A first question obviously is: why would you want this? Well, for several reasons actually.
Andreas 'ads' Scherbaum: Michael Christofides
Dave Page: Tuning max_wal_size in PostgreSQL
Bo Peng: Installing Pgpool-II on Debian/Ubuntu
First of all, many thanks to the PostgreSQL Global Development Group (PGDG) for creating Pgpool-II packages for Debian and Ubuntu.
This post shows you step by step how to install Pgpool-II using official APT repository provided by PGDG.
PrerequisitesThis blog assumes you have already installed two PostgreSQL 14 servers and setup streaming replication between the PostgreSQL servers.
cary huang: Distributed Database With PostgreSQL – Atomic Commit Problems
If you are into distributed database research, especially one that is setup using Foreign Data Wrapper (FDW) + partitioned foreign tables, you probably have heard that there are many potential issues associated with this setup. Atomic commit, atomic visibility and global deadlock detection are one of the most popular issues that one can encounter in a distributed database environment.
Shaun M. Thomas: PG Phriday: Wrapping Transactions Right Round
Hubert 'depesz' Lubaczewski: PGDayPL postponed…
Devrim GÜNDÜZ: New repo: Extra packages for PostgreSQL RPM repo
So, in order not to break some users' environment, I added new repos:
Joshua Tolley: Using pgTAP to automate database testing
Photo from PxHere
Recently I started learning to tune pianos. There are many techniques and variations, but the traditional method, and the one apparently most accepted by ardent piano tuning purists, involves tuning one note to a reference, tuning several other notes in relation to the first, and testing the results by listening closely to different combinations of notes.
Martin Davis: Spatial Filters in pg_featureserv with CQL
pg_featureserv provides access to the powerful spatial database capabilities of PostGIS and PostgreSQL via a lightweight web service. To do this, it implements the OGC API for Features (OAPIF) RESTful protocol.
Sergey Pronin: Run PostgreSQL on Kubernetes with Percona Operator & Pulumi
Avoid vendor lock-in, provide a private Database-as-a-Service for internal teams, quickly deploy-test-destroy databases with CI/CD pipeline – these are some of the most common use cases for running databases on Kubernetes with operators. Percona Distribution for PostgreSQL Operator enables users to do exactly that and more.
Laurenz Albe: Pipeline mode for better PostgreSQL performance on slow networks
© Laurenz Albe 2022
It is known that high network latency is bad for database performance. PostgreSQL v14 has introduced “pipeline mode” for the libpq C API, which is particularly useful to get decent performance over high-latency network connections. If you are using a hosted database in “the cloud”, then this article might be interesting for you.
Andreas 'ads' Scherbaum: Jaime Casanova
Oleg Bartunov: One TOAST fits ALL: JSONB TOASTER
Below is a performance analysis of JSONB, which uses JSONB TOASTER implemented using TOAST API.
Each jsonb looks like: key1, looong key2[], key3, loong key4[]. Check slide #10 of our talk at pgvision 2021 for description of data and queries used in benchmarks.