Chasing Postgres Performance

Chasing Database Performance Part 1 In a Series of Chasing Postgres Performance Over my years as a systems administrator, I’ve lost count of the number of databases that I’ve set up, and all of the idiosyncratic one-off scenarios that I’ve been forced to deal with. It’s not often that I get to work with a brand new database, trying to find out what works best right off the bat. I’m usually dealing with arcane requirements for applications that have extremely specific requirements (read legacy software), and so it’s expected that the database is set up in a certain way. Continue reading

What Is a Microenterprise and Why Does it Matter?

What is a Micro-Enterprise? Micro-enterprises are defined as a business organization with 9 employees or fewer 12. These are typically small family-owned businesses. In the context of IT, this can be extended to any organization that lacks a dedicated IT staff. Typically, a small business will only be concerned with the production of goods and services; unfortunately, technology has become integral with the operations of many small businesses. Inventory needs to be monitored, orders need to be shipped, and sales needs to be made–the integration of technology and business is therefore critical to success. Continue reading

Creating Systemd Timer Jobs

Systemd Timer Jobs In the past, it would be fairly typical to use cron to schedule jobs on Linux or BSD. Cron is an excellent tool for scheduling simple jobs, but weaknesses will begin to appear when complexity is required. Some of the benefits of systemd include: Automatic rotaion of logs. Memory/CPU scheduling. Random start/job delays. We’ll cover services and timers today. Timers The first step to creating a recurring job using systemd is to create the timer unit itself. Continue reading