[pgadmin-support] VACUUM FULL Error

Поиск
Список
Период
Сортировка
От Hayes, Patrick
Тема [pgadmin-support] VACUUM FULL Error
Дата
Msg-id BLUPR01MB161779DFE44B0D6F54512FE6FB6B0@BLUPR01MB1617.prod.exchangelabs.com
обсуждение исходный текст
Ответы Re: [pgadmin-support] VACUUM FULL Error  (Melvin Davidson <melvin6925@yahoo.com>)
Список pgadmin-support

Hi pgAdmin support,

 

Recently truncated tables in Postgre SQL DB and now unable to free up disk space on server with the VACUUM FULL command.

The DB is 1.91TBytes in size.

Server is running Win 2008 R2 Standard Operating System.

Postgre SQL is version 8.1

 

Error message reads as follows:

ERROR:  out of memory

DETAIL:  Failed on request of size 134217728.

 

Adding memory to server does not seem to make any difference. Re-starting the server makes no difference. The VACUUM command always ends in the same record 134217728.

Is there any way to selectively VACUUM tables – divide and conquer approach.

Thank you in advance for any support you can provide

 

Patrick Hayes

 

В списке pgadmin-support по дате отправления:

Предыдущее
От: Irina Mileva
Дата:
Сообщение: Re: [pgadmin-support] Restoring Db
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: [pgadmin-support] VACUUM FULL Error