From: | "E(dot)J(dot) Moloney" <emoloney(at)valetechnology(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Vacuum issue |
Date: | 2007-07-05 11:02:09 |
Message-ID: | 638790375.01183629749968.JavaMail.root@mailserver |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a database with a table that adds 30000 records a day, I am
delete records older than 2 days.
I am vacuuming it once a day , I am having an issue that the disk usage
is continually rising. i.e. the space been flagged as free by the vacuum
process isn't being reused.
Please find below a copy of the cron command being used.
0 0 * * * /data/newsam/scripts/samdatabasemaint.sh >/dev/null 2>&1
Relevent section from script
COMMAND="$prefix/bin/vacuumdb"
# What to use to shut down the postmaster
set -e
# Only start if we can find the postmaster.
test -x $DAEMON || exit 0
# Parse command line parameters.
su - $PGUSER -c "$COMMAND --analyze -v " >>$PGLOG 2>&1
exit 0
I orgionaly had autovacuum active but that encountered the sam issue
I am running Postgre 8.4 on a Susse 10.1
Thanks in advance for any help
E.J. Moloney
From | Date | Subject | |
---|---|---|---|
Next Message | Artur Rataj | 2007-07-05 11:44:25 | How to get fast ~ operator using C locale |
Previous Message | Patrick Carroll | 2007-07-05 10:21:28 | Re: Large Project, Integration with existing Oracle and MS SQL |