Re: big database with very small dump !? SOLVED

Поиск
Список
Период
Сортировка
От Joao Ferreira gmail
Тема Re: big database with very small dump !? SOLVED
Дата
Msg-id 1218558305.6460.64.camel@jmf-ubuntu
обсуждение исходный текст
Ответ на Re: big database with very small dump !?  (Tommy Gildseth <tommy.gildseth@usit.uio.no>)
Список 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.
>
>


В списке pgsql-general по дате отправления:

Предыдущее
От: William Garrison
Дата:
Сообщение: Re: ftell error during pg_dump
Следующее
От: Bill Moran
Дата:
Сообщение: Re: automatic REINDEX-ing