From: | "E(dot)J(dot) Moloney" <emoloney(at)moloneyodeaassociates(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Vacuum issue |
Date: | 2007-07-05 12:17:13 |
Message-ID: | 542298532.21183634254354.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 | Merlin Moncure | 2007-07-05 12:50:37 | Re: How to get fast ~ operator using C locale |
Previous Message | Artur Rataj | 2007-07-05 12:11:24 | Re: How to get fast ~ operator using C locale |