Re: Database growth problem

From: "Mendola Gaetano" <mendola(at)bigfoot(dot)com>
To: "mlaks" <mlaks(at)bellatlantic(dot)net>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Database growth problem
Date: 2003-07-18 07:36:34
Message-ID: 004401c34cff$50a46b70$10d4a8c0@mm.eutelsat.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"mlaks" <mlaks(at)bellatlantic(dot)net> wrote:
> But I run vaccuum analyze at the same frequency as on the PC's? How is it
that
> deleting and saving and vacuum analyze doesnt keep it at a normal svelte
<1Gb
> in size?
>
> What should I do to shrink it back down to its normal svelte shape?

Did you try to vacuum full and reindex the big tables ?

Regards
Gaetano
Mendola

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Andreas Schmitz 2003-07-18 08:23:36 Using temp tables
Previous Message A.Bhuvaneswaran 2003-07-18 05:20:34 Re: Adding PL/Perl