Autovacuum ro prevent wraparound

Поиск
Список
Период
Сортировка
От Steve Erickson
Тема Autovacuum ro prevent wraparound
Дата
Msg-id 3d7c19194d69425384139d73461f5aef@BLUPR07MB052.namprd07.prod.outlook.com
обсуждение исходный текст
Ответы wxWidgets Debug Alert assert "sizeNew == -1"  (John Abraham <jea@hbaspecto.com>)
Список 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 по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: Future of "Apply" button
Следующее
От: John Abraham
Дата:
Сообщение: wxWidgets Debug Alert assert "sizeNew == -1"