Neues vom PostgreSQL Planet
Takayuki Tsunakawa: Introducing a new community wiki page "Operations cheat sheet"
This is a short announcement of a new PostgreSQL wiki page called Operations cheat sheet . I curated many useful pages (that I find so), mostly from blogs registered in Planet PostgreSQL . Also, I summarized some topics for quick reference. I created this page so that users can learn from rich wisdom PostgreSQL community people and get ready for troubleshooting. For details, please see the Introduction section.
Ricardo Zavaleta: Benchmarking Postgres Vector Search approaches: Pgvector vs Lantern
Vector search in Postgres is a space that has seen very active development in the last few months. While Pgvector is known to most people, a few weeks ago we came across Lantern, which also builds a Postgres-based vector database. So, we thought about benchmarking both to compare the two approaches. In this post, we'll cover:
Luca Ferrari: Installing PL/Java on PostgreSQL 16 and Rocky Linux
A short recap on some issues when dealing with PL/Java and Rocky Linux.
Installing PL/Java on PostgreSQL 16 and Rocky LinuxIt has been a while since I last used PL/Java, and that’s mostly due to the fact that I (luckily) use much more Perl (and hence, PL/Perl) in my everyday activity than Java.
Hans-Juergen Schoenig: Optimizing PostgreSQL functions with preloaded libraries
In PostgreSQL, functions and procedures can be written in many different programming languages including but not limited to PL/pgSQL, PL/Perl, PL/Python and a lot more. This flexibility gives the end user the choice to write code in languages of their choice. However, this flexibility has some implications which are often forgotten. Loading libraries early is one of them.
Tristen Raab: JSON in PostgreSQL: Revolutionizing Data Flexibility in Your Database
In this blog, we’ll go over PostgreSQL’s implementation and handling of JSON objects. Having some experience with Linux, Postgres, and JSON is necessary as we’ll not only be going over these new features but also how to implement them. This blog was written using PostgreSQL 16 (Development Version) running on Ubuntu 23.04. First I’ll go over some background on JSON as a short refresher, then move on to how we use JSON in Postgres, followed by what helpful functions we can use to interact with JSON objects.
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 17 – ALTER TABLE command to change generation expression
Greg Sabino Mullane: Postgres Postmaster File Explained
You may have noticed a file called postmaster.pid inside your data directory. This file gets created when Postgres first starts up, and gets removed on a clean shutdown. It seems to contain some random numbers and strings, but what do they all mean?
The file will look like this:
2757 /home/greg/pg/17/data 176540940 5432 /tmp * 8675309 12 readyHere is a quick cheat sheet of the contents:
Henrietta Dombrovskaya: The Optimization Book Second Edition Is Here!
Today was the day - our PostgreSQL Query Optimization book was published! The book is currently available on Apress website, and if you are interested in the paper book, I believe that’s the fastest way to get it.
Melanie Plageman: You should submit a Postgres talk to the CFP for PGConf.dev
The PGConf.dev CFP closes on Monday, January 15 at 11:59pm PST, so if you want to speak at the inaugural PGConf.dev, submit a proposal!
PGConf.dev is the new PostgreSQL Development Conference, the successor to PGCon, a Postgres contribution-focused conference that took place every year in Ottawa. Pronounced "Pee-gee-conf-dot-dev", the inaugural year of PGConf.dev will take place in beautiful Vancouver, Canada, on May 28-31, 2024—with many of the same conference features that made PGCon so great:
Lukas Fittl: Introducing pg_query for Postgres 16 - Parsing SQL/JSON, Windows support, PL/pgSQL parse mode & more
Jan Karremans: Cloud Services and Fully Managed Postgres
There is no getting around “The Cloud”. We all know it, everybody is doing it!
And, let’s face it, if you are looking to get away from the hardship of having to go through troublesome and boring processes to get a new server or a new rack installed in your data center, this might help.
muhammad ali: Logical Replication in PostgreSQL
Understand the components involved in logical replication, how it differentiates from streaming replication and the factors to consider.
The post Logical Replication in PostgreSQL appeared first on Stormatics.
Sergey Pronin: Create an AI Expert With Open Source Tools and pgvector
Robert Haas: Incremental Backups: Evergreen and Other Use Cases
As of this writing, I know of three ways to make use of the incremental backup feature that I committed near the end of last month. I'll be interested to see how people deploy in practice. The first idea is to replace some of the full backups you're currently doing with incremental backups, saving backup time and network transfer.
Filipe Cabaco: Elixir clustering using Postgres
Hubert 'depesz' Lubaczewski: Waiting for PostgreSQL 17 – Add support for incremental backup.
Jeremy Schneider: Copy-and-Paste A New Postgres Dev Env In 5 Min
You can cut-and-paste the following commands to quickly get a new & clean dev environment for working with PostgreSQL source code. This includes Michael Paquier’s powerful script kit for managing the PostgreSQL development environment.
Setting up from scratch takes me about 5 minutes, plus 3 minutes to configure, compile and install PostgreSQL for testing. Running the full PostgreSQL test suite (including TAP tests) took me 13 minutes.