Neues vom PostgreSQL Planet

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

Bruce Momjian: Email Etiquette

8. September 2023 - 16:30

While a recent Postgres survey indicates that email lists are an impediment to new people getting involved with the project, email continues to be the primary means of communication in the community. Some of the reasons are historical, some are based on email's distributed nature, and some on email's flexibility of expression.

Pavlo Golub: Indexing `LIKE` Filters

8. September 2023 - 15:40

Markus Winand wrote a great article about why and how users should use LIKE operator in their workloads. It covers different approaches like Full-Text Search, Partial Index, Trigram Index, Materialized View, and query optimization.

Luca Ferrari: Using Emacs and YASnippet to quickly write PostgreSQL functions

8. September 2023 - 2:00

How a simple snippet can allow you to save time and improve your PostgreSQL code quality.

Using Emacs and YASnippet to quickly write PostgreSQL functions

I love Emacs, and I also love PostgreSQL.
Whenever I have to write PostgreSQL code, I use Emacs.
Emacs can help me improving code quality, for example to write PostgreSQL functions. I use YASnippet as a package to provide the basic template for a PostgreSQL function.

Gabriele Bartolini: How CloudNativePG manages physical replication slots for PostgreSQL in Kubernetes

7. September 2023 - 22:12
CloudNativePG has a native mechanism that provides an automated way to manage physical replication slots in a high availability Postgres cluster, with one or more hot standby replicas, and lets them survive a failover. This article describes why this is important for self-healing in Kubernetes. [Continue reading...]

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 17 – Allow \watch queries to stop on minimum rows returned

7. September 2023 - 12:47
On 29th of August 2023, Daniel Gustafsson committed patch: Allow \watch queries to stop on minimum rows returned   When running a repeat query with \watch in psql, it can be helpful to be able to stop the watch process when the query no longer returns the expected amount of rows. An example would be … Continue reading "Waiting for PostgreSQL 17 – Allow \watch queries to stop on minimum rows returned"

muhammad ali: Exploring Postgres Performance: A Deep Dive into pg_stat_statements

6. September 2023 - 15:00

Introduction pg_stat_statements is a built-in PostgreSQL extension that keeps track of SQL statements executed by the database server. It records details about query execution counts, total execution time and I/O related info. By capturing this information, database administrators can identify bottlenecks and optimize queries for better overall performance. In this blog, we’ll take a  look […]

Samay Sharma: Tembo Stacks: Making Postgres the Everything Database

6. September 2023 - 2:00

For years, Postgres has been considered among the most popular and advanced open source OLTP databases. Interestingly, 20 years ago, it was a competition between Postgres and MySQL and this debate is still going on today. 🙂 Over the last few years, Postgres added more features and its ecosystem added more extensions and now the comparison list keeps growing.

Greg Richardson: pgvector v0.5.0: Faster semantic search with HNSW indexes

6. September 2023 - 2:00
Increase performance in pgvector using HNSW indexes

Shane Borden: “Row Movement” in PostgreSQL… Is it bad?

5. September 2023 - 22:25

In Oracle, right or wrong, I was always taught to try to avoid “row movement” between partitions due to the general thought that the extra workload of a “delete” + “insert” (rewrite of the row) should be avoided due to the extra I/O, index fragmentation and the associated risks of a migrating ROWID in the cases where the app developers might have used it in their code (now that’s a whole other problem). Oracle didn’t even let you do it by default.

Table by table, you had to explicitly set:

Bruce Momjian: PostgreSQL Benefits and Challenges: A Snapshot

5. September 2023 - 16:30

Ivan Panchenko wrote a great article about why and how businesses should start using Postgres. It covers Postgres's structural benefits like vendor independence, code quality, and technology like NoSQL. It also covers the challenges that could be faced, like cost, time, and in-house expertise.

Francesco Tisiot: Machine Learning challenge: Chihuahua vs Muffin with PostgreSQL and pgvector

5. September 2023 - 10:14

Is it a Muffin or a Chihuahua?

I tried to solve the famous meme using #PostgreSQL pgvector extension. The results are really impressive!

Do you want to try? I created a Python notebook that can give you a jump start, check it out at

You can find the training dataset at

Christoph Berg: Exclusion constraints in PostgreSQL and a tricky problem

5. September 2023 - 10:00

Exclusion constraints are a feature that is not very well known, but can be used to implement highly sophisticated constraints. A few years ago, Hans wrote his blog post about EXCLUDE USING GIST… WITH.

Edco Wallet: How to Postgres on Kubernetes, part 2

5. September 2023 - 8:39
In part one, Nathan Koopmans, cloud platform engineer at OptimaData, showed how to create a simple plain PostgreSQL setup. Even though this works fine, you still want more data security. Therefore, in this second part, we look at the CloudNativePG operator for Kubernetes.

Peter Eisentraut: PostgreSQL make install times revisited

5. September 2023 - 6:00

We continue our exploration of PostgreSQL build system performance. A long time ago, I wrote an article about how to optimize the performance of make install. This was quite helpful, as it reduced the time from 10.493 s by default to 1.654 s with some tweaks (6x faster). Now, with different hardware, a much newer PostgreSQL, and a new build system looming, let’s take another look.

Greg Richardson: pgvector v0.5.0: Faster semantic search with HNSW indexes

5. September 2023 - 2:00
Increase performance in pgvector using HNSW indexes

Regina Obe: PostgreSQL 16 64-bit for Windows FDWs

3. September 2023 - 6:13

We are pleased to provide binaries for file_textarray_fdw and odbc_fdw for PostgreSQL 16 Windows 64-bit.

To use these, copy the files into your PostgreSQL 16 Windows 64-bit install folders in same named folders and then run CREATE EXTENSION as usual in the databases of your choice. More details in the packaged README.txt

These were compiled against PostgreSQL 16rc1, but should work fine against EDB PostgreSQL 16beta3.

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 17 – Generate new LOG for “trust” connections under log_connections

1. September 2023 - 23:44
On 26th of August 2023, Michael Paquier committed patch: Generate new LOG for "trust" connections under log_connections   Adding an extra LOG for connections that have not set an authn ID, like when the "trust" authentication method is used, is useful for audit purposes.

Bruce Momjian: Community Edition

1. September 2023 - 21:15

Related to my previous blog entry about bait and switch, I have heard people struggle to distinguish between binaries based on source code released by the Postgres community and binaries based on modifications of the community source code. The term "community edition" has often been used to represent binaries in the first category.

Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 17 – Add to_bin() and to_oct().

1. September 2023 - 15:27
On 23rd of August 2023, Nathan Bossart committed patch: Add to_bin() and to_oct().   This commit introduces functions for converting numbers to their equivalent binary and octal representations. Also, the base conversion code for these functions and to_hex() has been moved to a common helper function.   Co-authored-by: Eric Radman Reviewed-by: Ian Barwick, Dag Lem, … Continue reading "Waiting for PostgreSQL 17 – Add to_bin() and to_oct()."

Christopher Winslett: HNSW Indexes with Postgres and pgvector

1. September 2023 - 15:00

Postgres’ pgvector extension recently added HNSW as a new index type for vector data. This levels up the database for vector-based embeddings output by AI models. A few months ago, we had written about approximate nearest neighbor pgvector performance using the available list-based indexes. Now, with the addition of HNSW, pgvector can use the latest graph based algorithms to approximate nearest neighbor queries.