Archive for 'Database' Category

Using Partitioning on Zabbix DB tables to improve performance

By jbayer - Last updated: Monday, March 5, 2012

This script will partition your zabbix database to improve the efficiency. It will also create stored procedures to do the necessary housekeeping, and create a cronjob to do this on a daily basis. This script was inspired by the following: While the basic SQL is from the above page, this script both creates the necessary SQL for the […]


Installing PostgreSql 8.3 on Ubuntu 10.04 or later (Karmic)

By jbayer - Last updated: Tuesday, May 31, 2011

Ubuntu started shipping  Postgresql 8.4 with Karmic (10.04).  Postgresql 8.3 is not available in the Karmic or later repositories. If you need 8.3 for an application, you can easily install it by using the following steps: At the command line: echo “deb karmic main universe multiverse” >>/etc/apt/sources.list apt-get update apt-get install postgresql-8.3 sed -i […]