Re: Full vacuuming of BIG tables takes too long - Mailing list pgsql-admin

From Tom Lane
Subject Re: Full vacuuming of BIG tables takes too long
Date
Msg-id 17005.1053612483@sss.pgh.pa.us
Whole thread Raw
In response to Full vacuuming of BIG tables takes too long  ("Eugene M. Zheganin" <emz@norma.perm.ru>)
List 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 by date:

Previous
From: "A.Bhuvaneswaran"
Date:
Subject: Re: SECURITY
Next
From: Steve Crawford
Date:
Subject: Re: Full vacuuming of BIG tables takes too long