Browsing Category
Database
4 posts
Subcategories
Deploy a PostgreSQL database with an initial schema using Ansible
Ansible is a great automation tool to manage operating systems, but also to manage database like PostgreSQL. Many…
Perl: Create schema backups in PostgreSQL
At my recent job, I was asked to create a backup procedure, which would dump a PostgreSQL schema…
Postgresql: Monitor sequence scans with Perl
Not using indexes or huge tables without indexes, can have a very negative impact on the duration of…
Postgresql: Monitor unused indexes
Working on large database systems, with many tables and many indexes, it is easy to loose the overview…