Autovacuum ro prevent wraparound

From: Steve Erickson <serickson(at)digitiliti(dot)com>
To: "pgAdmin Support (pgadmin-support(at)postgresql(dot)org)" <pgadmin-support(at)postgresql(dot)org>
Subject: Autovacuum ro prevent wraparound
Date: 2014-01-06 17:27:39
Message-ID: 3d7c19194d69425384139d73461f5aef@BLUPR07MB052.namprd07.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I'm running PostgreSQL 8.4 on Ubuntu. While Postgres was do three autovacuums (to prevent wraparound) on three really large tables the root (/) directory filled to 100%. The filesystem for Postgres (/dev/mapper/db_vg-db_lv mounted on /db) has 56% of its space available. While Postgres was running, as soon as I'd free up some space in the root file system, some process would gobble it up. I stopped the Postgres service and immediately 7.5 GB freed up in the root filesystem.

Does Postgres use disk space outside of its own filesystem/directory tree? Is there a setting in the conf file so this can be directed to another filesystem (such as the /db)?

Thanks,

Steve Erickson
Senior Developer

NOTICE: This email, including any attachments, is covered by the Electronic Communications Privacy Act, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify our office by return email or at our telephone number (651) 925-3200. Then delete and destroy all copies of this email and any attachments.

Thank you.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message John Abraham 2014-01-06 22:38:03 wxWidgets Debug Alert assert "sizeNew == -1"
Previous Message Dave Page 2014-01-06 09:02:29 Re: Future of "Apply" button