Re: Full vacuuming of BIG tables takes too long

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Eugene M(dot) Zheganin" <emz(at)norma(dot)perm(dot)ru>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Full vacuuming of BIG tables takes too long
Date: 2003-05-22 14:08:03
Message-ID: 17005.1053612483@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Eugene M. Zheganin" <emz(at)norma(dot)perm(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Steve Crawford 2003-05-22 15:11:59 Re: Full vacuuming of BIG tables takes too long
Previous Message Josh Goldberg 2003-05-22 14:04:46 Re: user defined function call problem after upgrade 7.2.3 -> 7.3.2