↓
Menu ↓
  • News, articles and stuff
    • Development
      • Perl
      • Web
    • Media
      • Photo
      • Video
  • Media
    • Photography
  • About

Johnny Morano's Blog

Geek talk, extreme sports and travels

Johnny Morano's Blog
Home Menu ↓
Skip to primary content
Skip to secondary content
  • Home
  • About
  • Media
    • Photography
  • News, articles and stuff
Home→Categories Database

Category Archives: Database

Perl: Create schema backups in PostgreSQL

Posted on August 22, 2014 by Johnny MoranoNovember 4, 2014

At my recent job, I was asked to create a backup procedure, which would dump a PostgreSQL schema to a compressed file and which was able to create weekly and daily backups. The backups had to be full backups each … Continue reading →

Posted in Blog, Database, Development, Perl, PostgreSQL | Tagged Dev, Perl, Postgresql, SysAdmin | Leave a reply

Postgresql: Monitor sequence scans with Perl

Posted on February 12, 2014 by Johnny MoranoFebruary 12, 2014

Not using indexes or huge tables without indexes, can have a very negative impact on the duration of a SQL query. The query planner will decide to make a sequence scan, which means that the query will go through the … Continue reading →

Posted in Blog, Database, Development, Perl, PostgreSQL | Tagged Dev, Perl, Postgresql, SysAdmin | 3 Replies

Postgresql: Monitor unused indexes

Posted on February 11, 2014 by Johnny MoranoFebruary 11, 2014

Working on large database systems, with many tables and many indexes, it is easy to loose the overview on what is actually being used and what is just consuming unwanted disk space. If indexes are not closely monitored, they could … Continue reading →

Posted in Blog, Database, Development, Perl, PostgreSQL | Tagged Dev, Perl, Postgresql, SysAdmin | 2 Replies
© 2018 - Johnny Morano's Blog
↑