Re: big database with very small dump !? SOLVED

From: Joao Ferreira gmail <joao(dot)miguel(dot)c(dot)ferreira(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: big database with very small dump !? SOLVED
Date: 2008-08-12 16:25:05
Message-ID: 1218558305.6460.64.camel@jmf-ubuntu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi guys,

If found the reason for all this problem.

explanation: vacuum reindex cron scripts were not being executed.

I executed the operations by hand and the values became normal.

thank you all for the fine discussion.

joao

On Tue, 2008-08-12 at 13:49 +0200, Tommy Gildseth wrote:
> Joao Ferreira gmail wrote:
> > On Mon, 2008-08-11 at 10:58 -0600, Scott Marlowe wrote:
> >
> > If I try cluster, I'm guessing I'll choose the big index and forget
> > about the smaller ones... is this right ?
> >
>
> CLUSTER will sort out all the indexes, even though you're just
> clustering on on.
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2008-08-12 16:26:44 Re: automatic REINDEX-ing
Previous Message William Garrison 2008-08-12 16:21:45 Re: ftell error during pg_dump