root/trunk/table_growth/README

Revision 144, 2.4 kB (checked in by ssteinpreis, 4 years ago)

removed M from ends of lines using dos2unix

Line 
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
Note: See TracBrowser for help on using the browser.