Vacuum issue - Mailing list pgsql-general

From E.J. Moloney
Subject Vacuum issue
Date
Msg-id 542298532.21183634254354.JavaMail.root@mailserver
Whole thread Raw
Responses Re: Vacuum issue  (Michael Fuhr <mike@fuhr.org>)
List 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


pgsql-general by date:

Previous
From: "Artur Rataj"
Date:
Subject: Re: How to get fast ~ operator using C locale
Next
From: "Merlin Moncure"
Date:
Subject: Re: How to get fast ~ operator using C locale