Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
The PostgreSQL community is growing every year and the same happens for pgconf.eu, which happened in Athens, Greece, this year. Attending this event is one of the best opportunities to get in touch with the people behind PostgreSQL. This year we had 778 attendees. May it be PostgreSQL hackers, users, developers, organizers or anyone else interested in PostgreSQL in some…
Here’s the following day 2 of the PostgreSQL Conference Europe 2024 in Athens, if you haven’t read the first day here is the link. After a fantastic first day, I was excited to dive into the next day of the conference, which offered a mix of technical sessions that covered essential topics like upgrading PostgreSQL, handling statistics, and even taking…
Attending PostgreSQL Conference Europe 2024 in Athens is an incredible experience, full of enriching conversations and technical deep dives. As a DBA Consultant and speaker (on the reserve list and honored to have been chosen), it was my first time meeting this amazing community in person and I was immediately struck by the camaraderie and shared passion for PostgreSQL. The…
PostgreSQL 17 introduces new features for working with JSON data. These features align PostgreSQL more closely with the SQL/JSON standard and improve the developer experience when dealing with semi-structured data. In this blog, we will explore the new JSON capabilities by walking through real-world examples using a table with a jsonb column. The JSON Data Challenge for Web Developers When…
PostgreSQL 17 came with quite some additional features for the optimizer. One of them is about “is null” and “is not null” handling when column have a “not null” constraint defined. In the past it was common to just not add a “is not null” to a query when you are anyway sure that there cannot be any nulls because…
Up to now, there is no official way in PostgreSQL to tweak optimizer statistics manually. While this is quite common in other relational databases, PostgreSQL did not provide anything to do this. The first steps to allow this have now been committed for PostgreSQL 18. Before look at the two new functions which have been added, let’s create a small…
I had the opportunity to participate the SQL Server conference event (SQL KONFERENZ 2024) with my collegue Nathan Courtine.Independent from each other we chose exactly the same sessions as we are both interested in topics like Security, Performance Tuning, Azure and Artificial Intelligence (AI). For me, it was a great pleasure to see all those guys – from which I…
With the just released version of 17 of PostgreSQL, copy got the “ON_ERROR” switch. This is very useful if you load something which contains rows that cannot be inserted into the target table. Before that, copy would just stop and error out. The only option was to fix the data and then copy again. Using on “ON_ERROR”, copy can be…
A customer of mine had a recurring issue with one of his business critical applications where everything was frozen and stuck for the users. The issue was caused due to a head blocking transaction which increased blocking in the database exponentially. Depending on your technical background, you may know that locking is a very important mechanism in relational database systems…
In database management, query performance is critical for efficient data retrieval. PostgreSQL, a powerful open-source database, offers various extensions to optimize and tune query performance. Two such extensions are Index Advisor and HypoPG. These tools help database administrators (DBAs) identify and test potential indexes to improve query performance without the overhead of creating and dropping indexes repeatedly. This blog will…
Introduction I wrote this article to show how you can integrate Legacy OEM with your Cloud environment in this case Oracle ExaCC.To have overall view on your Exadata X9M Cloud Infrastructure, statistics related to CPU/Memory/ASM Storage usage. Your on premise monitoring OEM can read data from Oracle cloud using OCI libraries and present them in combination with your standard DB/VMs…
Introduction This is upgrade procedure to release update from 07 Aug 2024. 13.5.0.23 Its also one of prerequisites for integrating OEM with OCI Exadata Cloud@Customer solution available on my other post under this link: https://www.dbi-services.com/blog/exacc-oci-integration-with-oem-13-5-cloud-control-installed-on-premises Patching procedure and process is basically regular with usage of standard OMSPatcher. We updating from version 13.5.0.16 to 13.5.0.23 This update release bring some improvements…
