Neues vom PostgreSQL Planet
As I introduced in the past posts (, , ), we have proposed to implement Incremental View Maintenance (IVM) support in PostgreSQL core. This project is aiming to add the new feature into PostgreSQL in future, but not to make a tool that enables the current PostgreSQL to use IVM.
Transaction ID Wraparound occurs when the VACUUM process cannot keep up with database activity and the PostgreSQL service is forced to shut down.
In more technical parlance: Transaction ID Wraparound occurs when the semantics of Multi-Version Concurrency Control (MVCC) fail and when the number of unique transaction ids reaches its maximum which numbers about two billion.
What leads up to this situation is when the VACUUM process managed by either the autovacuum workers or user-interaction (manual) does not keep up with the DML operations.
Editing SQL and PostgreSQL related code within Emacs, in a beautiful war!
Range types have been around in PostgreSQL for quite some time and are successfully used by developers to store various kinds of intervals with upper and lower bounds. However, in PostgreSQL 14 a major new feature has been added to the database which makes this feature even more powerful: multiranges. To help you understand multiranges, I have compiled a brief introduction outlining the basic concepts and most important features.
PostGIS is one of the most awesome extensions for PostgreSQL and can turn a relational database into a really powerful GIS (Geographic Information System). The PostGIS community is really great about documentation and training and this post is aimed at getting you some resources on how to get started with the major components of using PostGIS as a super beginner.
Attention - In had to change signature of nvl2 function in Orafce. With this change, the behave is much more close to Oracle's nvl2 function. Unfortunately, this change can break extension update when some users use nvl2 function in views. The related views should be dropped first, and after extension update should be created again.
How great it is pgbadger?
The Postgres.ai team is happy to announce the release of version 3.1 of Database Lab Engine (DLE), the most advanced open-source software ever released that empowers development, testing, and troubleshooting environments for fast-growing projects. The use of Database Lab Engine 3.1 provides a competitive advantage to companies via implementing the "Shift-left testing" approach in software development.
Date and time are relevant to pretty much every PostgreSQL application. A new function was added to PostgreSQL 14 to solve a problem which has caused challenges for many users out there over the years: How can we map timestamps to time bins? The function is called date_bin.
With the Russian invasion of Ukraine, there is renewed focus on the use of Postgres by governments, particularly uses that might further military goals.
On Thursday and Friday of this week we will be enjoying 90 degree weather and sunshine in San Jose, California. It will be quite the change from the dark and damp of NW Washington. This is also the first time I will have been on an airplane in almost 3 years. Yes, it really has been that long since the world decided to begin a pandemic. That said, I am excited for Postgres Conference Silicon Valley 2022 and in particular the following sessions:
An Event for Postgres is a free and virtual developer event organized by the Postgres team at Microsoft Azure.