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

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