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.
While preparing myself for the pgconf.eu in Berlin this week I made a lot of research regarding Patroni and pgBackRest. I was aware that it’s possible to recreate a replica from a pgBackRest backup. But I was also wondering, what happens if the complete Patroni Cluster is gone. I know this is not the most common case, but never say…
2022.pgconf.eu is currently happening in Berlin. We have a record number of 600 attendees, this makes it the largest ever PostgreSQL Conference Europe and we’re hitting the hard limits of the venue. But even with that number of people it still feels comfortable. Just before the opening started yesterday, this is how the room looked like: When it finally started…
By Mouhamadou Diaw Patching an ODA is always exciting. Preparing a patch of an ODA HA may seem more complicated that an single ODA. But it’s the same processus. All patching operations should be run on one node. In this document I am describing the patch of a ODA HA from 19.14 to 19.16 with a customer. Great thanks to…
Intro Let me present you in this Blog post a useful tool to asset your Azure environment and in a second step show you how to add Azure SQL managed instance in the assessment report. ARI presentation Azure Resource Inventory is an open-source project developed in PowerShell that allows you to quickly generate a complete Excel report of your Azure…
This blog will be the first of a series of blogs, to report about my experiences with Google Cloud SQL. In this blog we will setup a basic PostgreSQL instance in the Google Cloud. If you’re new to Google Cloud, Google offers every new customer a amount of 300$/90 day trial (https://cloud.google.com/docs/get-started )to test their services. Google Cloud will guide…
The Oracle Exchange Partition is a method allowing to : exchange the data segments from a non partitioned table to a partitioned table exchange the data segments from a partitioned table to a non partitioned table. This method is useful because: You can get data quickly in or out of partitioned table You can convert non partitioned table to a…
After having fun with my ACE friends on previous day ACE dinner and Oracle CloudWorld party (next pictures might speak by themselves) it was time to be back on sessions and meetings for the last day at Las Vegas. Without forgetting the great concert given by Steve Miller Band. Oracle Database In-Memory: Best Practices and Use Cases [LRN3515] This session…
Let’s go for my third day in Las Vegas with more Oracle sessions and meetings. Also I was more than surprised this morning to meet for the first time, in the lift of the hotel, Carlos Ortiz, Sr. Principal Product Manager at Oracle, with whom I have been recently in contacts for tomorrow ODA CAB meeting! We could walk together,…
In the last post we’ve looked into how you can build PostgreSQL with Meson instead of the traditional way using configure/make. The reason for this was a thread on hackers which described the downsides of the traditional approach and explained the advantages of using Meson. Some of the advantages mentioned were the time required for the build, readability of the…
Full day of sessions! I have been able to participate to some really good and great sessions I would like to share with you. Driving Impactful Business Results [KEY1866] The day began with the keynote from Safra Catz. My first impression. Wow. We can see the work to organize such a session and how many people would have been helping…
Last year, around this time, there started a thread on hackers which was about building PostgreSQL with meson. I didn’t know anything about Meson at this time, and don’t know much more right now, but as it seems to be related to build times and times to get test results I though I’ll have a look (there are more, and…
In a recent customer project, I was suffering to delete millions of rows from a LOG table. Removing 3 months of data took more than 30 minutes with the best optimization possible. After a while, I remembered that a very nice oracle feature existing since Oracle 12cR1 enables us to archive rows automatically. Let’s me explain you how it works:…
