| 1 |
NAME |
|---|
| 2 |
|
|---|
| 3 |
table_growth - a set of scripts for reporting table size growth in postgres |
|---|
| 4 |
|
|---|
| 5 |
SYNOPSIS |
|---|
| 6 |
|
|---|
| 7 |
A set of schema, functions, and shell script to report table size growth. |
|---|
| 8 |
|
|---|
| 9 |
|
|---|
| 10 |
VERSION |
|---|
| 11 |
|
|---|
| 12 |
This document refers to version 0.2 of table_growth, released December 9th, |
|---|
| 13 |
2008 |
|---|
| 14 |
|
|---|
| 15 |
USAGE |
|---|
| 16 |
|
|---|
| 17 |
To use table_growth, you need to add the schema for holding table size |
|---|
| 18 |
information, install the included functions into your database, set up a cron |
|---|
| 19 |
job to do the data population, and set up a cron job to send the reports. We |
|---|
| 20 |
typically setup the conr jobs to look like this: |
|---|
| 21 |
|
|---|
| 22 |
15 0 * * * psql -c "select otools.collect_table_growth(); select |
|---|
| 23 |
otools.summarize_table_growth(); " 1>/dev/null |
|---|
| 24 |
|
|---|
| 25 |
45 6 1 * * /var/lib/pgsql/scripts/table_growth_report.sh 1>/dev/null |
|---|
| 26 |
|
|---|
| 27 |
BUGS AND LIMITATIONS |
|---|
| 28 |
|
|---|
| 29 |
The package is designed to work on single databases at a time, if you want to |
|---|
| 30 |
report on multiple databases in a cluster, you will need to install this in |
|---|
| 31 |
each individual database, and also set cron jobs independently for each |
|---|
| 32 |
database. |
|---|
| 33 |
|
|---|
| 34 |
Some actions may not work on older versions of Postgres (before 8.1) |
|---|
| 35 |
|
|---|
| 36 |
Please report any problems to robert@omniti.com. |
|---|
| 37 |
|
|---|
| 38 |
TODO |
|---|
| 39 |
|
|---|
| 40 |
LICENSE AND COPYRIGHT |
|---|
| 41 |
|
|---|
| 42 |
Copyright (c) 2008 OmniTI, Inc. |
|---|
| 43 |
|
|---|
| 44 |
Redistribution and use in source and binary forms, with or without |
|---|
| 45 |
modification, are permitted provided that the following conditions are met: |
|---|
| 46 |
|
|---|
| 47 |
1. Redistributions of source code must retain the above copyright notice, |
|---|
| 48 |
this list of conditions and the following disclaimer. |
|---|
| 49 |
2. Redistributions in binary form must reproduce the above copyright notice, |
|---|
| 50 |
this list of conditions and the following disclaimer in the documentation |
|---|
| 51 |
and/or other materials provided with the distribution. |
|---|
| 52 |
|
|---|
| 53 |
|
|---|
| 54 |
THIS SOFTWARE IS PROVIDED BY THE AUTHOR "AS IS" AND ANY EXPRESS OR IMPLIED |
|---|
| 55 |
WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF |
|---|
| 56 |
MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO |
|---|
| 57 |
EVENT SHALL THE AUTHOR BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, |
|---|
| 58 |
SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, |
|---|
| 59 |
PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR |
|---|
| 60 |
BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER |
|---|
| 61 |
IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) |
|---|
| 62 |
ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE |
|---|
| 63 |
POSSIBILITY OF SUCH DAMAGE. |
|---|
| 64 |
|
|---|
