Vacuum issue
От | E.J. Moloney |
---|---|
Тема | Vacuum issue |
Дата | |
Msg-id | 638790375.01183629749968.JavaMail.root@mailserver обсуждение исходный текст |
Ответы |
Re: Vacuum issue
|
Список | 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 по дате отправления: