PostgreSQL PostgreSQL on Linux: what is cached? 14.02.2021 by Open source Team By Franck Pachot . In a recent tweet I wanted to highlight the importance of knowing what you measure with pgbench, because looking at “Transactions per second” without knowing if you are in shared buffer cache hits, or filesystem(…)
Operating systems SUSE Manager installation 13.02.2021 by Open source Team In this Blog I will write the requirements and steps to install SUSE Manager Server. Maybe you heard about SUSE Manager but you could not understand why a SUSE Manager Server (SUMA) can help to manage your(…)
Operating systems CentOS 8 alternatives 11.02.2021 by Open source Team Many people are unhappy about the decision from the CentOS Board of Directors, to switch from fix releases to Stream and cutting the support date from 2029 to 31st of December 2021 for CentOS 8. Many applications in productive environments(…)
PostgreSQL Microsoft Flexible Server for PostgreSQL 11.02.2021 by Open source Team This Blog is about some findings on Microsoft’s new Flexible Server offering for PostgreSQL which is in Customer Preview at the moment. Findings about the infrastructure The Microsoft Flexible Server for PostgreSQL is using Ubuntu as OS infrastructure, I think(…)
Database Administration & Monitoring, Database management, PostgreSQL PostgreSQL High Availability: Patroni, Ectd , HAProxy , Keepalived 03.02.2021 by Open source Team By Mouhamadou Diaw Patroni is one the most famous tool that can be used to setup a high avalaibilty for PostgreSQL. In this blog I am describing a test I did. Below the environment we will(…)
Cloud, PostgreSQL Google Cloud SQL Insights: ASH, plans and statement tagging 31.01.2021 by Open source Team By Franck Pachot . Looking at database performance has always been necessary to optimize the response time or throughput, but when it comes to public cloud where you are charged by resource usage, performance tuning is critical for cost(…)
Cloud Exoscale scaling up and down 30.12.2020 by Open source Team In my previous Blog I had wrote about Swiss Cloud Provider: Exoscale. Read the Blog Today we will look little bit deeper in three subjects: Template & Template sharing Scaling up and down instances dbi(…)
Database Administration & Monitoring Running two Patroni on one host using an existing etcd 23.12.2020 by Open source Team Have you ever asked yourself, how to create a second Patroni PostgreSQL cluster on an existing server using the existing etcd? My first idea was to study the documentation of Patroni, but unfortunately without big(…)
AWS, NoSQL DynamoDB Scan: the most efficient operation 😉 20.12.2020 by Open source Team By Franck Pachot . The title is provocative on purpose because you can read in many places that you should avoid scans, and that Scan operations are less efficient than other operations in DynamoDB. I(…)
Cloud, PostgreSQL Recovery in the ☁ with Google Cloud SQL (PostgreSQL) 11.12.2020 by Open source Team By Franck Pachot . In a previous post I started this series of “Recovery in the ☁” with the Oracle Autonomous database. My goal is to explain the recovery procedures, especially the Point-In-Time recovery procedures(…)