Autovacuum ro prevent wraparound
От | Steve Erickson |
---|---|
Тема | Autovacuum ro prevent wraparound |
Дата | |
Msg-id | 3d7c19194d69425384139d73461f5aef@BLUPR07MB052.namprd07.prod.outlook.com обсуждение исходный текст |
Ответы |
wxWidgets Debug Alert assert "sizeNew == -1"
|
Список | pgadmin-support |
<div class="WordSection1"><p class="MsoNormal">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 forPostgres (/dev/mapper/db_vg-db_lv mounted on /db) has 56% of its space available. While Postgres was running, as soonas I’d free up some space in the root file system, some process would gobble it up. I stopped the Postgres service andimmediately 7.5 GB freed up in the root filesystem.<p class="MsoNormal"> <p class="MsoNormal">Does Postgres use disk spaceoutside of its own filesystem/directory tree? Is there a setting in the conf file so this can be directed to anotherfilesystem (such as the /db)? <p class="MsoNormal"> <p class="MsoNormal">Thanks,<p class="MsoNormal"> <p class="MsoNormal">SteveErickson<p class="MsoNormal">Senior Developer<p class="MsoNormal"> <p class="MsoNormal">NOTICE: Thisemail, including any attachments, is covered by the Electronic Communications Privacy Act, is confidential and may belegally 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 communicationin error, please immediately notify our office by return email or at our telephone number (651) 925-3200. Thendelete and destroy all copies of this email and any attachments.<p class="MsoNormal"> <p class="MsoNormal">Thank you.<pclass="MsoNormal"> </div>
В списке pgadmin-support по дате отправления: