Infrastructure at your Service

 
Daniel Westermann

About temp_tablespaces in PostgreSQL

By | Database Administration & Monitoring | One Comment

There often is a discussion if tablespaces should be used in PostgreSQL. People used to work with Oracle are often a bit surprised by this discussion as there is no way around using tablespaces in that technology. PostgreSQL does not force you to use tablespaces at all and I am pretty sure that there are plenty of PostgreSQL installations out there that do not use them and never even considered using them and that is…

Read More
Franck Pachot

ysql_bench: the YugaByteDB version of pgbench

By | Postgres | No Comments

By Franck Pachot . This follows the previous post on testing YugaByteDB 2.1 performance with pgbench: https://blog.dbi-services.com/yugabytedb-2-1/ A distributed database needs to reduce inter-node synchronization latency and then replaces two-phase pessimistic locking by optimistic concurrency control in many places. This means more serialization errors where a transaction may have to be re-tried. But the PostgreSQL pgbench does not have this possibility and this makes benchmarking distributed database very hard. For example when CERN tested CoackroachDB…

Read More
Franck Pachot

YugaByteDB 2.1: the Open Source multi-region distributed database with PostgreSQL API is in GA with huge performance improvement

By | Postgres | No Comments

By Franck Pachot . 9 months ago I was looking at YugaByteDB which was still in beta version for its ‘YSQL’ API. I published my first test on Medium: https://medium.com/@FranckPachot/running-pgbench-on-yugabytedb-1-3-3a15450dfa42. I have been very enthusiastic about the idea, the architecture, the way they open-sourced it and how all was documented in their blog. I’ve even met them in Sunnyvale when I traveled to California for Oracle Open World. Great people with a great vision on…

Read More
Daniel Westermann

Collations in PostgreSQL – basics

By | Database Administration & Monitoring | No Comments

When you work with databases sooner or later you will need to get in touch witch collations. It might be that you never needed to think about it as initdb picked a value that just worked for you and nobody in your database ever tried to use a collation that is not available in your installation. Once someone is trying that or there is the requirement to use a specific collation from the beginning you…

Read More
Nathan Courtine

Restore S3 Object with AWSPOWERSHELL

By | Cloud | No Comments

AWS S3 offers different Storage Classes, allowing to optimize cost among others. For instance, some classes are used for archiving purposes: S3 Glacier and S3 Glacier Deep Archive. It means the storage cost is the lowest you can obtain, but your data is not available immediately and the access cost is increased. In the case of S3 archive classes, retrieving the data is not cost-effective because this is clearly not what it is aimed for….

Read More
Mamy Rasoanaivo

How to automate a kill of one or several executing jobs in AJF at specific Date/Time at once

By | Control-M | No Comments

Introduction We had a request to automate a kill of some executing jobs in AJF at specific date and time. For example: A Control-M job is running a script all day, in order other programs can connect to it, but the script has to be stopped at a specific time. There are several ways to manage that, such as: using in Action Tab, use Notifications before job completion, then run a Shout to a script…

Read More

SQL Server: Collect Page Split events using Extended Event session

By | Database Administration & Monitoring, SQL Server | No Comments

Earlier this week someone tried to show me how to capture page split events using Extended Events (XE) but unfortunately, the demo failed. This is a good opportunity for me to refresh my knowledge about page split and set up a simple demo about this. Hopefully, this one will be working. It’s not necessarily a bad thing when a page split occurs. It’s a totally fine behavior when we INSERT a row in a table…

Read More

Control M /EM : Mass update,some examples on how to use it

By | Control-M, Postgres | No Comments

Introduction:   We are back today to write about a powerful tool that we can use to update our folders.   Question: Suppose you have to update two jobs of your folder; the task should be easy. But what happens when you must update 50 jobs in a restricted delay? Solution:   To get this easier and smarter we will use the find and update tool. We will use the find and update tool: To…

Read More
Franck Pachot

Refactoring procedural to SQL – an example with MySQL Sakila

By | Development & Performance | 4 Comments

By Franck Pachot What I want to show in this blog post is that, as in mathematics where you have to apply some algebra rules to transform an equation to an equivalent one, the database developer must translate the business specification to an equivalent that is optimized (in performance, reliability and readability) for the data model. I was looking at the Sakila sample database provided with MySQL. It simulates a DVD rental store. For my…

Read More
Arnaud Berbier

DevOpsDays 2020 at HEG in Geneva

By | Application integration & Middleware, DevOps, Kubernetes, Technology Survey | No Comments

This 2020 new year began with a really exiting DevOps Event in Geneva. Kubernetes, Helm, Cloud Native, CNCF, CI/CD, Ansible, Terraform,… So much topics around DevOps that was in every people mouth. This confirm that DevOps is a good choice for any retraining 😉 This is effectively the next generation in the IT world. For this second edition, around 300 peoples were attending the event. Thanks to the organizers During the 1st day, I attended…

Read More

Control M/EM : Shout destination tables graphic and cmd mode

By | Control-M | No Comments

Introduction : Today we will check how to use notification by using shout destination table, indeed sometime it could be useful to be notified about our jobs status ( long execution, late submission failure etc..). For that kind of need we can use job notifications through shout method. We will explain it below: We will use shout destination table to manage notification To call scripts We will define shout destination and test it with jobs….

Read More