Re: Full vacuuming of BIG tables takes too long

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Full vacuuming of BIG tables takes too long
Дата
Msg-id 17005.1053612483@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Full vacuuming of BIG tables takes too long  ("Eugene M. Zheganin" <emz@norma.perm.ru>)
Список pgsql-admin
"Eugene M. Zheganin" <emz@norma.perm.ru> writes:
>   Just example. I have an table in ISP billing base, which every 2
>   months grows and contains up to 35,000,000 of records. That takes
>   13Gb of disk space. On that amount 'vacuum analyze' (every night) is
>   inefficient, cause after it the table continues to grow (but not
>   very fast).

If you aren't getting results from plain vacuum then you need to
increase your FSM settings.

            regards, tom lane

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

Предыдущее
От: "A.Bhuvaneswaran"
Дата:
Сообщение: Re: SECURITY
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: Full vacuuming of BIG tables takes too long