Re: Database growth problem - Mailing list pgsql-admin

From Mendola Gaetano
Subject Re: Database growth problem
Date
Msg-id 004401c34cff$50a46b70$10d4a8c0@mm.eutelsat.org
Whole thread Raw
In response to Database growth problem  (mlaks <mlaks@bellatlantic.net>)
List pgsql-admin
"mlaks" <mlaks@bellatlantic.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



pgsql-admin by date:

Previous
From: "A.Bhuvaneswaran"
Date:
Subject: Re: Adding PL/Perl
Next
From: Dani Oderbolz
Date:
Subject: Re: pg_dump: dumpBlobs(): error reading large object: ERROR: